Power BI Heat Map is useful to display the data along with the colours. By seeing the colour one can understand the profits easily.
In this article, we will show you, How to Create a Heat Map in Power BI with an example.
For this Power BI Heatmap demonstration, we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Heat Map in Power BI
In order to create a Power BI heatmap, first, click on the Matrix under the Visualization section. This will automatically create a Matrix with dummy data.
Next, drag and drop the English Country Region Name to the Column Group, and product Color to the Row Group. Now, you can see a Matrix without values.
Next, let me drag the Sales Amount to the Values section. This will automatically enable the Row totals and grand totals
Please click on the Format button to convert this Matrix into a Heatmap in Power BI. I suggest you refer Format a Matrix article to understand the formatting options.
First, go to the Grid Section. As you can see from the below screenshot, we changed the row padding to 18 and text size to 15
By toggling Row subtotals, column subtotals under the Subtotals section to Off you can remove the Totals completely. So, let me remove them
Column Header section of Power BI Heatmap helps us to alter the Headers. As you can see from the below screenshot, we changed the Font Family to Cambria, Outline to Top + Bottom (Outline will be added to the top and bottom of a Header), Text Size to 22, and Header text alignment to centre.
The row Header section of Power BI Heatmap helps us to format the Row Headers section. Here, we changed the Outline to Left + Right (Outline is added to the Left and Right of Header Column i.e., Color), Font Family to Cambria, Text Size to 22, and text alignment to centre.
Power BI Heatmap Example
To connect that matrix to Power BI heatmap, go to the Conditional Formatting section to add colours to the Matrix Numeric column.
As you can see from the below screenshot, we selected the Sales Amount as the field and toggled the background color scale property to On. This will add a default colour to the matrix. I mean, default color to Power BI Heatmap
Change Power BI Heatmap Color
To change the Power BI heatmap color, click on the Advanced option. This will open the following window. If you are interested in two colours then select the Minimum colour and maximum colour.
We check marked Diverging option. Next, we selected some random colours as the minimum, Center, and Maximum values.
Now you see the Power BI Heatmap with the selected colours.
Thank You for Visiting Our Blog