Creating a Table Heatmap in Power BI

The Table Heatmap visual is a great way to compare data values in an easy and intuitive way. You can create a Table Heatmap in Power BI by using conditional formatting on Matrix visual.

So, Let’s start with an example, download the sample Dataset from below link

• Global Super Store Dataset

Let’s get started-

Step-1: Add a Matrix visual into Power BI report page and drag year, month & sales columns in fields section.

Step-2: Select Matrix visual & go to format bar and follow these steps-

• Style – Select None.
• Grid – Turned on Horizontal & Vertical grid, and choose some light grey color for Horizontal & Vertical grid color. And give Row padding 5px.
• Increase the font size for – Column header, Row header & Values.
• Subtotals – Turned off Row Subtotals & Column subtotals.

After implement all above things your visual look like as below-

Step-3: Right click on Sales column > Choose Conditional formatting > Click on Background color.

Step-4: Background color windows dialogue box opens, now click on Diverging check box and assign colors for minimum, center & maximum values.

Step-5: see the output, Table heatmap has been ready.

How to hide sale values on visual?

Follow these steps in order to hide values on visual –

Step-1: Follow the step number-3, Right click on Sales column > Choose condition formatting > click on Font color.

Step-2: Choose same color which you select for Background color, follow step number-4.

Step-3: See the final output-

Refer other Power BI topics: Power BI tutorials

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.