top of page
Search

⚡Risk Matrix Viz - Power BI Custom Visual

  • Writer: Tyron Stewart
    Tyron Stewart
  • Apr 22
  • 2 min read

Updated: Jul 15

Risk Matrices are used globally by project managers across diverse industries, from cyber security to mining, to assess and communicate risk.While preparing for a client engagement, I looked for a Power BI visual to support this. Existing visuals lacked the flexibility I needed, and the workaround processes were too time-consuming.

So, I built one.


Risk Matrix Viz

The Risk Matrix Viz is a certified custom visual designed to streamline the visualisation of risk likelihood and impact in Power BI. It solves the problem of laborious manual setups and limited customisation by offering a dynamic drag-and-drop risk matrix builder that works intuitively. 


Risk Matrix Viz custom visual in Power BI

Here are are some of the key features:


Effortless Drag & Drop

Default 5x5 risk matrix

Quickly create a fully interactive risk matrix by simply dragging and dropping fields.

No complex setup required.




Custom Dimensions

Custom 3x3 and 4x4 risk matrix

The Risk Matrix Viz dimensions can be customised to suit your needs.

Most project management users opt for 3x3, 4x4, or 5x5, but the option is yours to a maximum of 9x9 matrix cells.

Unconventional layouts such as 9x3 or 4x7 are also available.

Risk Levels are set independently of Rows and Columns for maximum flexibility.

Set your own number of Risk Levels and name them to suit your case.




Dynamic Colour Customisation

3 different risk matrices with different colouring settings

Turn on Use Gradient Colours to view the transition of colours from low to high in gradient style as an alternative to solid colors.

Add an optional Data Circle. Change the Colour of your Data values, make them Bold or Underlined.

The default colours are AAA rated for contrast and accessibility.

However, you can choose your own colours manually, apply conditional formatting with a DAX measure or with rules.




More Flexible Formatting

2 risk matrices with more formatting customisations

Swap Axes positions and format axes titles independently.

Add a matrix header background and choose your own header text and background color combination.

Choose your own matrix cell width or height.

Add grid lines, cell padding or even add rounded corners to your cells if you choose.




Drill Through Functionality

illustrating drill through functionality of the risk matrix

The Drill through Key field placeholder allows users to right click on a cell and drill through to another page to see all the rows of data included in that matrix cell value.




Access


The Risk Matrix Viz certified custom visual is publicly available on Microsoft AppSource.

Updates

Updates are occasionally made. However, as the visual is certified, these updates can take up to 2 weeks to reach production.

Moreover, even though the new version may be displayed on AppSource, the new capabilities can take a further 2 weeks to take effect (Microsoft certification timelines).

To receive updates, please return to the Blog home page and click 'Subscribe'.




 
 
 

2 Comments


Dougal Hanson
Dougal Hanson
Aug 26

How are you meant to format your data for this to work ? I can't get the Viz to show anything. Have tried both a simple matrix data format, with counts in the cells, and also a full expanded list of every combination of Likelihood x Impact

Like
Tyron Stewart
Tyron Stewart
Aug 26
Replying to

Hi Dougal,

Thanks for your question! The Risk Matrix Viz expects the data in a specific structure to display correctly. The easiest way to see how your data should be formatted is to download the sample dataset from the AppSource file, which comes with a step-by-step guide (https://appsource.microsoft.com/en-us/product/power-bi-visuals/dataloomptyltd1737368383376.riskmatrixvizoffer?tab=DetailsAndSupport)


Screenshot of Download button
Download Sample Report

Sample Dataset in the Sample Report
Sample Dataset in the Sample Report

In summary:

  • You need a table where each row represents a single risk item (not aggregated counts).

  • There should be columns for Likelihood and Impact (see the sample file).

  • There should be a measure for Risk Count (see the sample file).


If your data matches this structure and you add the 2 columns and the measure to their allocated placeholders in the build pane, the visual displays the risk matrix.

Hope that…

Like
bottom of page