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…
Knowing how to use the CALCULATE function is like knowing a cool super power. We’re going to learn the basics of it today, but it’s extremely versatile.The CALCULATE function performs a calculation on data but then lets you specify what data you want that calculation done on. Let’s try it out. We’re…
This post is a little different. No video this week, because we’re talking about Power BI Licenses. Not the most exciting thing in the world but *immensely* important to understand when it comes to sharing Power BI reports in your organization. Let’s learn about how Power BI license levels affect…
The COUNT function in DAX is nice and easy. Let’s learn what it does (I think you can guess what it does) so we can all use it when we need it in our DAX measures. We’re using a very simple dataset to learn the COUNT function. If you’d like…
The SUMX function in DAX is very similar to the SUM function (makes sense, right?) but with 1 key difference We’re going to use a very simple dataset to demonstrate how the SUMX function works.If you’d like to use the same data that I do in the below video, here…
Oh, we’re getting a bit fancy with Power BI in this post! We’re going to learn how to change the data source of a report, and what you need when you do this so that everything doesn’t break. Not breaking things is a good goal, and not hard once you know what…