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

Creating a Table Heatmap in Power BI

Heatmap Power BI

The Table Heatmap visual is a great way to compare data easily and intuitively using colors in a table. You can create a Table Heatmap in Power BI by using conditional formatting on Matrix visual.

Let’s get started-

Download the sample Dataset from below link-

Global_superstore_2016.xls

Following these steps to create a table heatmap-

Step-1: Import Orders dataset from Global superstore file.




Step-2: Add Matrix visual into Power BI report canvas, and drag below columns-

Rows: Market, Columns: Year, Values: Sales

Matrix visuals

Matrix visuals

Step-3: Select Matrix visual > Go to Format section 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.





Step-4: After that Right click on Sales column > Choose Conditional formatting > Select Background color.

Conditional formatting background color

Conditional formatting background color

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

Background color Diverging

Background color Diverging




Step-6: Now you can see the final result-

Table heatmap visual

Table heatmap visual

How to hide Sales values on visual?

Follow these steps to hide values on visual –

Step-1: Right click on Sales column > choose Condition formatting > Select Font color.

Step-2: Font color dialogue box appears, now click on Diverging check box and choose same colors for minimum, center & maximum which you selected for Background color( See Step-5).

Step-3: See the final output-

Table heatmap Power BI

Table heatmap Power BI



Refer more Power BI visuals- Power BI Visuals

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.

Leave a Reply