In this post we’ll explore how to write a simple SUM formula using DAX, and also show an example of how you may want to use it. We’re going to use a very simple dataset and report to demonstrate how the SUM function works.The written instructions as well the Power…
It’s always important to align visuals in Power BI. Alignment helps organize how your reports look and helps your reports look more professional.There are 4 main ways to align visuals and we’ll go over them all in this post. We’re going to use a Power BI report that already has…
It’s Hot Tip time here on How To Use Power BI, and for this tip, we’re going to learn about Display Folders, a little hidden feature in the Model View of Power BI Desktop. They are going to be your new best friend if you have to build reports with…
One of Power BI’s great strengths is that we can easily create visuals and entire dashboards using data from multiple data sources. As long as the data has something in common (ideally a unique identifier – we’ll talk about that in a minute), we can link data sources together and make…
In this post we’re going to learn how to format Pie Charts.I highly recommend that before learning from this post you watch/read the post about how to make a Pie Chart, which goes over how NOT to make them as well. Pie Charts are your best chart option in very…
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…
