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.
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.