Get a sharp visual view on your risk profiles with the Risk Heatmap Visual for Microsoft Power BI! This visual is built to visualize profiles, that are measured in a matrix of two KPIs and different categories. It is able to visualize multiple indicators per field. You can freely and dynamically select all expressions between a 3×3 and 5×5 matrix. Various settings like custom colors, flexible border and text settings adapts this visual to your reporting needs.

Benefits

This visualization can also be used for monitoring and indicating thresholds for all types of physical measures, quality indicators and divergences in general. With this, it can be applied to a broad number of uses cases, that occur different businesses. The following listing shows a selection of possible uses cases, that had been already implemented:

Project Management: Visualize risk and opportunity profiles for a project, program or portfolio

IT: Indicate applications, that are in green, yellow or red area of status (performance, health)

Get It Now!

Getting Started with our Risk Heatmap Visual for Microsoft Power BI

Open Power BI and the relevant app, where you want to use the “Risk Heatmap” visual. Open your worksheet in edit mode and you will find the visual within the “Custom Objects” section. Drag and Drop the extension to any area on your dashboard (You can change the appearance of the visual later in the advanced settings).

After you have placed an instance of the extension to your dashboard, the following properties panel will appear on the right side. The properties panel is separated into the following sections:                                                                                              

  • Measures
  • Dimensions
  • Ranges (general matrix layout)
  • Grid Settings (everything inside the matrix)
  • Axis Settings (everything around the matrix)
  • Indicator Settings (everything regarding matrix-content)
  • About                                             

In the following , you will learn how to use LeapLytics “Risk Heatmap” extension and how to customize it to your needs by using the properties correctly.   


Measures

The measure defines the value for the relevant two KPIs of the matrix. The first KPI defines the X-Axis-KPIs and the second KPI defines the Y-Axis-KPI. They can be switched individually. The matrix is expecting values in the range between 1 and 5 (5-field-matrix) or 1 and 3 (3-field-matrix). Also decimals are possible, if useful. The values can be taken from the data model directly, if a pre-system is already capturing and calculating the range. If the data model includes any kind of units, the categories can be created within the formular individually.

You can add a measure like this:

  • Click the “Add measure” button in the properties panel under the section “Measure” or by clicking the “Add measure” button inside the custom visual window on your dashboard
  • Choose a measure from the dropdown list and click on it
  • (Optional): Choose the right aggregation for your needs (Sum, Avg, Min, Max, etc.) or define an individual formula.

When using individual formulas, the following examples can be taken as a guidance:


Dimensions

Use the dimension in order to give the indicators a striking name. This can be e.g. an ID or short-name (1-2 words). Longer names or descriptions are not recommended, as the space of the matrix itself is limited.


Advanced Settings

Within the Matrix Settings you can make several selections.

Matrix Settings: First, you can fix the aspect ratio. This keeps the visualization in a square state. In addition, you can set the size of the x- and y-direction individually by using the slider. If your data is outside these ranges, you will get a visual hint in the visual! Furthermore you can invert the colors with one click. Finally, you can define the width of the border or disable it completely.

Grid Settings: Use the Grid Settings to configure the matrix itself, e.g. size or configuration of the borders. You can also invert the color-coding, that a higher category has the color “green” and a lower category is turning into red. It is also possible to switch off the table with detailed values.

Axis Settings: The Axis settings let you configure the frame to your needs. You can decide to switch off texts, axis or high/low-indication.

Indicator Settings: Use the indicator settings in order to change the size and appearance of the indicators in the Grid.


Version History

VersionDateContent
1.0.0.010.03.2022Initial Version