We’re going to learn a formatting tip in this edition of How To Use Power BI and it’s specifically about an annoying formatting limitation that is turned on in Power BI by default. There *IS* a very good reason for this limitation, but it doesn’t need to be on…
You probably don’t need legends on your Line Charts. Series Labels are an option on Line and Area charts and allows you to get rid of your Legend. Why would you want to get rid of your legend? We’ll cover that too! We’re going to use a Power BI report with…
We’re continuing our series of posts about connecting data with how to connect to data on a website! It’s nice and easy to connect to data on a website the data is nicely structured in some kind of table. So, it’s just like connecting to other kinds of data… Power…
This post is a Hot Tip post, helping you solve something in Power BI. Specifically, this post is about a user interface design flaw in the (relatively) new Card visual, and we run across it when we try to change the display units of a number in the visual. So,…
Did you ever have a large DAX calculation that had something (a column, another measure, etc) mentioned many times and when you had to change that item you had to select each one, one-at-a-time, and edit each one, one-at-a-time, and you thought “there’s gotta be a better way…?!” Good news!…
If you’ve already checked out the post about the IF function (I recommend it if you haven’t used IF functions in Power BI or in Excel before), this post is about how to use multiple IF statements nested within each other to check for different scenarios in your data.
The IF function in DAX is at once one of the simplest DAX functions and also one of the most powerful. If you’ve used the IF Excel formula in spreadsheets before, you’ll be happy to know that the IF DAX function behaves exactly the same. We’re going to use a…
Today we’re going to start learning all about Bookmarks in Power BI. Bookmarks can be used to do a lot of different things, but today we’re just going to learn the basics and future posts will explore different features and uses of them. A Power BI Bookmark can be…
Welcome everyone! This post is about how to fix one of the annoying things in Power BI that makes you say “What The…?” (or worse language) when it happens. Sometimes, when you get Power BI to do a calculation (a sum, a count, a division… lots of things) and it…
Everything you need to know about Bar Charts! Once you’ve connected to some data, you may want to build a Bar Chart. Bar Charts are easy to build, and more importantly, they are easy for people to understand.Bar charts compare categories of things by their value, using length. The following…