We’re here for more data documentation fun in this post. While we have a post about documenting our data tables and columns in Power BI Desktop proper, there’s also some unsung (but awesome) data *transformation* documenting options in Power Query Editor. Just like documenting where your data is…
This post is all about documenting what your columns and DAX measures are all about (and maybe why they exist) in Power BI. Your datasets (whether you use them with Power BI or not) should be documented regardless, but that’s a data governance topic for another place, but documenting your…
The ALL function in DAX is a simple yet extremely versatile function that let’s us override any filters or slicers that may be affecting what data is coming into a calculation or visual. We’re going to learn how it works with a simple example using a CALCULATE function. (I…
We’re taking on the simple yet incredibly useful DIVIDE DAX function today. This function has a cool piece in it that accounts for when your denominator is a 0. When you divide numbers in Excel, you’ll get at #DIV/0! error when your denominator is a 0 (because nothing can be…
This post is about the concept of Row Context in Power BI. This is SUPER important when it comes to writing DAX measures, but applies to visuals not using DAX as well. To explore more DAX posts, check the DAX tag. This post was made with…
Last year (2023), Microsoft released a new data product called “Fabric” and if one read all the Power BI news out there on the social mediums, etc, it at first seemed like Fabric was replacing Power BI. It did NOT replace it. It doesn’t even do the same thing.
We’re looking at a very cool feature that is found in Power Query Editor for this tutorial… namely the ability to create a new column that is based on another column. This is more impressive than it sounds, trust me. Post Subjects: Power Query We’re going to use a…
This post is a high level look at the SELECTEDVALUE DAX function. This function is at once extremely simple and straightforward but can be used in a myriad of ways to filter data, indicate if data is filtered, even manipulate your report design to look different ways based on what…
Let’s learn about Slicer Interactions. Sometimes, it’s handy if a Slicer only interacts with SOME visuals on your page and not all of them. Let’s learn how to make that happen. For this post (and the video below) we’re going to start with a simple pre-made Power BI file. It has…
Today we’re going to solve a very common problem that many bar charts have. It’s a problem I see all the time, and I bet you see it all the time too. It’s a problem that makes Bar Charts harder for your viewers to understand quickly. With Power BI, there’s…