Home » Power BI Visuals » Creating a Table Heatmap in Power BI

Creating a Table Heatmap in Power BI

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




Let’s get started-

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

Matrix Visual

Matrix Visual

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-

Matrix Visual Power BI

Matrix Visual Power BI

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

Conditional Formatting-

Conditional Formatting-





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

Background color

Background color

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

Table-HeatMap-PowerBI

Table-Heat Map-Power BI

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-

Matrix visual Table Heatmap

Matrix visual Table Heatmap

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.



Leave a Reply