We’re exploring a really common function that comes with Power Query editor today, and that’s how to promote column headers in your data if Power BI can’t figure out what your headers are.This post (and video below) uses a new blank Power BI report and connects some simple data to…
How to format a Line Chart in Power BI
This post is about how to implement basic formatting in a Line Chart in Power BI. When I say “basic” formatting, I mean what you should do EVERY time you build a Line Chart to make it as easy for your users to understand. For this post (and video) we’re…
How to make a Line Chart in Power BI
To learn how to make a Line Chart, we’re going to start off with a report that already has Excel data connected. If you need to learn how to connect data, go watch the Connecting to Excel Data post first. If you’d like to use the same Power BI file I…
An Introduction to Power Query Editor
We won’t get into too much detail about the nitty-gritty of each part of Power Query in this post. The Power Query tool is extremely powerful (and even has it’s own programming language), so we’ll have lots of posts about what it can do, but for now, we’ll start with…
Add a Benchmark Line to a Bar Chart in Power BI
Let’s learn how to add a benchmark line to a Bar Chart! Benchmark lines are great for showing progress towards (or beyond) a target. For this post we’re going to start with a Power BI file that already has a simple Bar Chart made, and we’re going to add a…
How to ALWAYS have the LATEST version of Power BI Desktop
Hey everyone here’s a quick but awesome tip for you that will make your life (or your IT dept’s life easier) when it comes to keeping Power BI Desktop updated so you always have the latest version.Microsoft rolls out updates to Power BI Desktop almost every month, and most…
How to Format a Bar Chart in Power BI
This post is about the basics/essentials of formatting a Bar Chart in Power BI. When I say formatting BASICS, I mean what you should do EVERY time you build a bar chart to make it as easy for your users to understand. For this post we’re going to start with…
The Filter Pane
In this post we’ll be going over the basics of the Power BI Filter Pane, including the many many ways we can use it to filter our visuals differently. We’ll be using a simple pre-built report to learn about the basics of the Filter Pane. You can download a copy…
How to make a Bar Chart in Power BI
Learn the basics of making a Bar Chart with this post. We won’t get into too much detail about the many things we can do with bar charts, but those will be their own tutorials. Video: Written Instructions: We’re going to start off with a report that already has Excel…
Connecting Power BI to Excel Data
We’ll be learning the basics of connecting to an Excel file in this tutorial. We’ll have other posts about connecting to other types of data sources. We’ll be connecting a super simple Excel spreadsheet in this post. If you’ve like to try it out with the same file, you…