Welcome to our post all about how to know when you should make a new column OR a new measure using DAX in Power BI, because sometimes it can be confusing about what is better. The answer, like most things, is “it depends”. If you want to use the…
Welcome to our post all about the DISTINCTCOUNT function in DAX, because sometimes a COUNT isn’t good enough because it counts duplicates. If you want to use the same Power BI file I use in the below video and written notes to try out DISTINCTCOUNT, here’s the pbix file…
Sometimes, you really really want to publish your Power BI report to the web so that everyone can see it (without needing a Power BI license – more on that here), and this post is about why you want to think twice (or thrice, or four-ice??) about doing this.
This How To Use Power BI post is all about how to make an impressive looking “Ring Donut” chart with Power BI, specifically using new border options Microsoft has added to Donut and Pie charts. The new border options are NOT super useful in terms of making charts better and…
Hey everyone! Welcome to this How To Use Power BI post, which is actually a How to NOT Use Power BI post. Freaky, right? This post isn’t a technical one that will show you what to click to get something done in Power BI, but more of a chart design…
Welcome to the searching formatting options post on How To Use Power BI. We’re going to look at a really simple and useful formatting feature that even I forget about, even though I’ve used Power BI almost every day for years and years and years. Maybe *I* am the only…
Everything you need to know about Pie Charts! Once you’ve connected to some data, you may want to build a Pie Chart. Pie Charts are easy to build and are so easy to build (in Power BI as well as other programs) that they are frequently used.Pie charts are excellent…
Welcome to the custom coloring pie chart labels post! This isn’t hard to do, but the option is hidden just a little bit. Once you know where it is, you’ll use it all the time. We’re going to use a simple Power BI file to get to know how to…
Welcome to the DAX:FORMAT post, where we’re going to learn the basics of the FORMAT function to format numbers for different circumstances. We’re going to use a simple Power BI file to get to know how to do this. If you’d like to use the same file, you can download…
Let’s learn how to use a fun little DAX function called SWITCH. The SWITCH function does just what it sounds like. It switches (see?) one value/thing for another value/thing. Or a list of values/things for a list of other values/things. We’re going to use a simple Power BI file to…