Power Query: Promoting column headers

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More