Create Heatmap for Power BI

Create Heatmap for Power BI


Step 1 – Get the visual


You can get the visual from our website, Microsoft AppSource or Power BI desktop/web.

a. Website - Go to the visual page and click on ‘Get Trial’ button. You will be redirected to the pricing page where you will provide your email id and click on the ‘Download Visual’ button.
You will receive a mail which will contain the link to download .pbiviz file and a free trial license.

Heatmap


Step 2 – Map your data in the fields available


After importing the visual in Power BI, map data in the given fields. Here we have mapped 'Day' in Horizontal Axis, 'Month' in Vertical Axis, ‘Commits’ in Color Value and Label and 'Date' in Tooltip.

Heatmap

In case you want to use Small multiples you can map the data to ‘Small multiple' field.



Step 3 – Format your visual further


a. License Details - If you want to check how your visual works in other Power BI platforms besides Power BI desktop, you have to fill License Details section.
To know more about License Details section, click here.

b. Layout Section – In case you don’t want to see the toolbar present on the top left of the visual, you can do that by Format Visual -> Layout -> Show Toolbar switch.

Heatmap

c. Fetch more data – In case you have lots of rows (>5000), you need to enable Fetch more data and give the number of rows that you expect in return.


d. Chart Section - Please follow this link to know more about this section.


e. Horizontal/Vertical Axis – You can format the Horizontal and Vertical Axis under these sections. You can choose axis color, axis label formatting, their placement on the screen and many more.
For more details visit Axis section.

f. Color axis – Under Color axis section, you can configure colors used in heatmap, the way they are mapped to values, color bar placement, etc.
For more details visit Color axis section.

g. Heatmap Section – Under Heatmap section, primarily the type of heatmap and its label properties are configured:

i. Heatmap properties – This section allows customization of heatmap display type:

Heatmap Chart

  • Transparency: Set the transparency level of the heatmap cells as a percentage (e.g., 50%)
  • Display: Choose how heatmap should be displayed (e.g., Full matrix, Upper left, Lower left)
  • Interpolate missing data: Toggle to enable or disable interpolation of missing data in the heatmap
  • Cell Gap: Set the gap between heatmap cells in pixels (e.g., 2 px)

ii. Label Properties – Allows Configuration of label's properties displayed on heatmap:

Heatmap Chart


Step 4 – Using visual to create complex heatmaps

Click any of the below link to know how heatmap can be utilized to create different types of charts: