PowerBI – Table Heat Map

Ever wondered how to create a heat map in PowerBI without having to use a custom visual? There is now a simple way to do this by using Conditional Formatting on a Matrix table!

In my example I took some Google Analytics data showing the times of the day and amount of visitors in that time.

Then plot the values on the Matrix table

Next we go and do some conditional formatting in the pane on the right hand side in PowerBI

Now we can change the colours we want to use by Selecting Advanced Controls

You will see that the table has turned into a heat map table using the conditional formatting with the colours you chose. As you can see below the highest value is pink and the lowest value is a light green and a gradient between the colours as the numbers range.

Just like that we have a heat map table with one simple step!