Get Started
The Powerviz Heatmap is easy to configure. In this section, you will learn how to create an advanced Heatmap. Installation Guides contain the installation process and instructions on Heatmap. Please note that the installation process is the same across all the visuals. You can see the user guide below. Now that you’ve successfully installed Powerviz Heatmap visual to Power BI, let’s start making the chart. Follow the below steps to get started with the Heatmap.
Steps:
Select the Heatmap visual from the visualization pane.
Add at least one Dimension into the Rows field.
Add at least one Dimension into the Columns field.
Add one Metric into the Measure field.
To create a hierarchy, insert multiple dimensions in the Row and Column fields from top to bottom, with the top column representing the parent node and the others its child nodes.
Finish!
Powerviz Heatmap is now ready.
INFO You can customize all the options in the heatmap except visual settings, legends, number formatting, and footer using advanced settings.
Field Requirements
We have the following fields available in the Heatmap field tab:
Rows: All the hierarchy dimensions should be dragged in the rows field from top to bottom to render on rows. You can add single or as many dimensions in the rows field.
Columns: All the hierarchy dimensions should be dragged in the columns field from top to bottom to render the columns. You can add single or as many dimensions in the rows field.
Measure: In the measure field, only one measure/numeric-type column can be added, and this value is used to divide the shapes.
Tooltip: It is a Power BI native option, you can use it to show additional information about each category on the tooltip. You can also use the tooltip to apply measure-type conditional formatting.
Data Label: In the Data Label field, you can add only one column, which can be either numeric or categorical, to display on the heatmap. This setting can be configured under the Advanced Settings in the Data Labe section.
Color Field: In the Color field, you can create a conditional color column and add it here to display colors based on specified conditions or based on your requirement.
Sort: Apply sorting based on any custom column. Drag the column into the Sort field and use from advanced settings to select the sorting order.
Show: This option allows you to control the visual rendering based on a specific rule. You need to add a Boolean-type (0 or 1) column or measure. If the output is 1, the visual will be visible; otherwise, the visual will show the error message. To know more about this option.
Last updated