Heat Map in Power BI

Last Updated :

-

Blog Author :

Jeevan A Y

Edited by :

Ashish Kumar Srivastav

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Table Of Contents

arrow

Power BI Heat Map

The heat map is a custom visualization available with Power BI to show the data numbers through presentation or visual. For example, the heat map will show the highest data density on one specific set of the area through dark heated color, and others will have the same heat as the highest value.

The latest trend is the sports area showing the analysis through a heat map. So, for example, if you take cricket sport, they show the batter's favorite hitting zone. Next, suppose you take bowlers; they show how consistently a bowler places the ball on one specific zone, yielding a wicket. Finally, if you take tennis, they show a player moving consistently in this court section, etc.

Below is the image of the tennis court heat map.

Heat map

Source: https://www.hawkeyeinnovations.com

Now, we will see how to build a heat map in Power BI visuals.

How to Build Heat Map in Power BI?

We need a certain set of numerical data to build a heat map. For example, below is the sales data in different cities in India.

Power Bi Heat map (Excel data)

Since this is our first try to build a heat map, let us start with a simple data set only. First, copy and paste the data directly to Power BI, or you can copy the data to an Excel file and then import it to Power BI as an Excel file reference. You can also download the Excel workbook from the link below, which is used for this example.

We have directly uploaded the data to Power BI.

Power Bi Heat map (Table data)

After this, we can build a heat map, but we do not have built-in visualization to use immediately.

Follow the below steps to download the custom visualization:

  1. But, first, go to the "Report" view.


    Power Bi Heat map (Report)

  2. Come to the "Visualizations" panel, click on the "Import a custom visual" (three dots at the bottom), and click on "Import from marketplace."


    Power Bi Heat map (Visualizations)

  3. It will take us to the web page of custom visuals if you have already signed into a Power BI account. Else, it will ask you to sign in.


    Power Bi Heat map (Sign in)

  4. Use your official email id sign. It will take you to the web page.

  5. In the search box, enter "Heat map" and search. You will see related search results.


    Power Bi Heat map (Marketplace)

  6. Click on the "Add" button now. We can see this new visual under “Visualizations” visuals.


    Power Bi Heat map (Heat Map)

  7. Click on this new visual. We will have a blank "heat map" in place.


    Power Bi Heat map (Heat map with no values)

  8. By selecting this visual, drag and drop the "City" column to the "Location (ID)" field and drag and drop the "Sales" column to the "Value" field.


    Power Bi Heat map (Drag and Drop field)

  9. Now, we have our "Heat Map" ready to use.


    Power Bi Heat map (Heat map output)

  10. Now, select the "Format" option by selecting the heat map.


    Power Bi Heat map (Format)

  11. Under "Renderer," select the "Type" as "Heat," "Radius" as "30," "Opacity" as "0.9", and "Measure" as "Sum."


    Power Bi Heat map (Renderer)

  Finally, our heat map looks like this.

Final Heat map

One interesting thing about this heat map is at the top of it, we can see a legend with different colors with different sales numbers for those colors.

legends

By using these color legends, we can easily read the heat map.

Build Table Heat Map in Power BI

A new addition to the heat map category is building a "Table Heat Map." Unfortunately, this is also not a built-in tool, so you must download it from the web.

Table Heat Map Add
  • Click on "Add." It will import it to the Power BI visuals category. We can see this under the "Visualizations" list.
Table Map Option
  • Insert blank “Table Heat Map.”
Table Heat map
  • Now, we need to drag and drop columns to our respective fields. For example, drag and drop "City" to the "Category" field and "Sales" to the "Y" field.
Table values

It will give us the table heat map like the one below.

Power Bi Heat map (Final Table Heat Map)

As you can see, each color indicates different numbers on the slab. We have applied format to this table so that you can do the same under the "Formatting" section.

Note: We have done so much formatting to this table. You can download the Power BI heat map file from the below link and apply each formatting technique as applied.

Things to Remember Here

  • The heat map is a custom visualization in Power BI, so we must insert it from the marketplace.
  • The Power BI heat map builds visualization based on numerical values only.
  • From the marketplace, we can download different kinds of heat map visualizations.