Let’s learn how to make everyone’s fave chart in Power BI, the Pie Chart!Just kidding, Pie Charts don’t get a ton of love in the data visualization world, and there are lots of situations when they should NOT be used, but there are also times when they SHOULD be used.So,…
Let’s learn about Slicers! Slicers are a LOT like Filters, but live right ON your Power BI report’s canvas so your report viewers can interact directly with them and decide how to slice and dice the data in the other visuals. For this post (and the video below) we’re going…
We’re going to learn a bit more about our Formatting options in Power BI Desktop in this post. Power BI has some page formatting options that are good to know about if you need them. Post Subjects: User Interface | Formatting The Page Formatting tools show up when…
Today we’re exploring how to merge columns Power Query Editor. Sometimes you get stuck with data where two columns have data that SHOULD be in one column. We’re going to learn how to easily bring them together. Post Subjects: Power Query This post (and video below) uses a new blank…
Today we’re exploring how to split a column in Power Query Editor. Sometimes you get stuck with two data points in one column and you need to split them out into different columns so you can visualize each, or use one of them in a slicer or a filter.This post…
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…
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…
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…
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…
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…
