New Map Styles in Power BI

Reading Time: 3 minutes The Power BI team recently added additional map styles for the Map and Filled Map that make them a more attractive option for data visualization. Alongside the Road and the Aerial themes, Power BI now has options for Light, Dark, and Grayscale. What do these options add, and why should you care? As I have…

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…

Building Horizon Graphs in Power BI

Reading Time: 5 minutes Horizon graphs are an intriguing but initially confusing way of looking at time series. Once you get familiar with the layout, you can simply think of it as a more space-efficient way of rendering a common line or area chart. Where there is a broad range in the data from low values to high values, horizon graphs condense…