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…
Hi everyone, Today we’re going to learn how to get more advanced with our Table visual column hiding (or showing). This post is kind of a continuation from the previous How To Post about how to control column visibility. Click here to check that post out… there’s stuff…
Today on How To Use Power BI we’re going to learn a really simple solution to a really common conundrum in the Power BI Table visual. If you spend any time on a Power BI forum / subreddit / whatever, you’ll eventually (or frequently) see someone asking the question…
Hey everyone, This post is all about the MAX function in DAX, which does exactly what you think it does… it finds the maximum value in a column of values. We’re going to use a very simple Power BI report (in both the video and the written post below) to…
Everything you need to know about Line Charts! Once you’ve connected to some data, you may want to build a Line Chart. Line Charts are easy to build, and more importantly, they are easy for people to understand.Line charts are excellent for showing data that has a time-based element. They…
Power BI is an extremely powerful piece of software, so it’s especially disappointing when Microsoft bills it as “data visualization” software and completely fails on small (but essential) things that take Data Viz from existing to excellent. This post explores one of these fails. We’re going to use a simple…