Heat Map in Power BI

Power BI Heat Map is useful to display the data along with the colors. By seeing the color, one can understand the profits easily. Let me 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 to Connect to SQL Server article to understand the Power BI Data Source.

How to Create a Heat Map in Power BI

To create a Power BI heatmap, first, click on the Matrix under the Visualization section. It automatically creates a Matrix with dummy data.

Desktop 1

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.

Matrix without Data 2

Next, let me drag the Sales Amount to the Values section. It automatically enables the Row totals and grand totals

Heat Map in Power BI 3

Please click on the Format button to convert this Matrix into a Heatmap in Power BI. I suggest you refer to Format a Matrix article to understand the formatting options.

Click the format button under Visualizations 4

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

Change Row padding and text size  5

By toggling Row subtotals, column subtotals under the Subtotals section to Off, you can remove the Totals completely. So, let me remove them

Turn Off Row and column subtotals 6

Column Header section of Power BI Heatmap helps us to alter the Headers. As you can see from the screenshot below, we changed the Font Family to Cambria. Next, Outline to Top + Bottom (Outline added to the top and bottom of a Header), Text Size to 22, and Header text alignment to center.

format column headers 7

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 added to the Left and Right of Header Column, i.e., Color). Next, Font Family to Cambria, Text Size to 22, and text alignment to center.

Format row headers of Heat Map in Power BI 8

Power BI Heatmap Example

To connect that matrix to Power BI heatmap, go to the Conditional Formatting section to add colors to the Matrix Numeric column.

As you can see from the screenshot below, we selected the Sales Amount as the field and toggled the background color scale property to On. It adds a default color to the matrix. I mean, default color to Power BI Heatmap.

Heat Map in Power BI 9

Change Power BI Heatmap Color

To change the Power BI heat map color, click on the Advanced option. It will open the following window. If you are interested in two colors, then select the Minimum color and maximum color.

Change Color 10

We check-marked the Diverging option. Next, we selected some random colors as the minimum, Center, and Maximum values.

Heat Map in Power BI 11

Now you see the Power BI Heat map with the selected colors.

Heat Map in Power BI 12

Comments are closed.