Using DAX to Normalize Data in Power BI

Reading Time: 2 minutes A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon chart and Slopegraph in Power BI without the use of custom visuals. In many cases, we can use DAX, selective filtering, or other tricks to…

10 Ways to Create Maps in Microsoft Power BI

Reading Time: 6 minutes Update March 19, 2018: There are now many more than 10 ways to create maps in Power BI. Get the free Exploring Maps in Microsoft Power BI whitepaper from BlueGranite, and view the companion webinar:  Whitepaper: https://www.blue-granite.com/maps-power-bi-whitepaper Webinar: https://www.blue-granite.com/maps-in-power-bi-mar-2018   Original Post: Last year, I wrote a post entitled 5 Ways to Create Maps in Microsoft Power BI. With the…

Every Detail Counts

Reading Time: 1 minute Recently, I encountered a visual created using Power BI’s default color theme that made me take a second look — for the wrong reason. I created an alternate visual that shows the same issue I noticed straightaway. Does anything quickly stand out? The default Power BI color theme assigns green, then black, then red in sequence. Sometimes,…

Creating Slopegraphs in Power BI

Reading Time: 1 minute Did you know that it’s easy to transform Power BI’s Line Chart into a Slopegraph? No DAX or fancy workarounds are required. Slopegraphs are a great way to judge the rate and magnitude of change by looking at the steepness of a line’s slope. With a slopegraph, it is also easier to discern how different elements…

Throwing a Curve at the Power BI Line Chart

Reading Time: 6 minutes Last month, I explored how to take a Power BI area chart and make it into a unique “new” chart type using only data and DAX formulas. The line chart is also a candidate for a bit more flare. How can we go from a bland line chart… …to a more attractive, curved slopegraph? Many…