Heat Map in Power BI

The heat map in power bi is a type of data visualization technique, and it is one of the customs made visualization in power bi, in this data visualization is used to show the density of any data on a map, the density is displayed in different colors.

Power BI Heat Map

Heat Map is a custom visualization available with Power BI to show the data numbers through presentation or visual. 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.

In the sports area showing the analysis through a heat map is the latest trend. You take cricket sport they show batsmen favorite hitting zone, you take bowler they show how consistently a bowler placing the ball on one specific zone which is yielding him a wicket, If you take tennis they show in this section of the court a player moving consistently, 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?

To build Heat Map, we need a certain set of numerical data. Below is the sales happened data in different cities of India.

Power Bi Heat map (Excel data)

Since this is our first try to build a heat map, let’s start with simple data set only. 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 below link, which is used for this example.

You can download this Heat Map in Power BI Excel Template here – Heat Map in Power BI Excel Template

I have directly uploaded the data to Power BI.

Power Bi Heat map (Table data)

After this, we can build a heat map, but we don’t have built-in visualization to use it straight away.

Follow the below steps to download the custom visualization

  1. Go to Report View.

    Power Bi Heat map (Report)

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

    Power Bi Heat map (Visualizations)

  3. This will take us to the web page of custom visuals if already signed into Power BI account, or else it will ask you to Sign in.

    Power Bi Heat map (Sign in)

  4. Using your official email id sign, and 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 visualization visuals.

    Power Bi Heat map (Heat Map)

  7. Click on this new visual, and 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, by selecting the heat map, come to the “Format” option.

    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)

After all this now, finally, our heat map looks like this.

Final Heat map

One interesting thing about this heat map is at the top of the heat map; we can see 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

One more new addition to the heat map category is building “Table Heat Map.” This is also not a built-in tool, so you need to download it from the web.

Table Heat Map Add
  • Click on Add, and this will be imported to the Power BI visuals category, and we can see this under the visualization list.
Table Map Option
  • Insert blank “Table Heat Map.”
Table Heat map
  • Now we need to drag and drop columns to respective fields. Drag and drop “City” to “Category” field and “Sales” to “Y” field.
Table values

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

Power Bi Heat map (Final Table Heat Map)

As you can see, each color indicates different numbers of the slab. I have applied to format to this table, so you can also do the same under the “Formatting” section.

Note: I have done so much of 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

  • Heat Map is a custom visualization in Power BI, so you need to insert it from the market place.
  • Power BI Heat Map builds visualization based on numerical values only.
  • From the market place, you can download a different kind of heat map visualizations.

Guide to Heat Map in Power BI. Here we discuss how to build a heat map using Power BI visualization to show the data numbers along with examples. You can learn more about Power BI from the following articles –

  • 6 Online Courses
  • 29+ Hours
  • Verifiable Certificate of Completion
  • Lifetime Access
LEARN MORE >>