Create Risk Matrix

Question

I have a data table in PowerBi and full of fines.

All the records have a category, # of individuals involved, and fine amount field.

I want to plot every category on a risk matrix (frequency vs severity) where the x-axis is frequency (sum of individuals involved of each category) and where the y-axis is severity (sum of fine amount of each category). And then the plots are labeled by category.

What would be the best way to accomplish this? I'm new to PowerBi so apologies if this is a silly question. Thanks

anonymous · Accepted Answer

Hi&nbsp; gojets1721&nbsp;,
&nbsp;
I created some data:

You can choose "Get more visuals" - Risk Matrix by Profitbase

Create calculated column:
frequency  =
COUNTX(
    FILTER(ALL('Table'),
    'Table'[category]=EARLIER('Table'[category])),[ of individuals involved])severity =
SUMX(
    FILTER(ALL('Table'),
    'Table'[category]=EARLIER('Table'[category])),[ of individuals involved])
&nbsp;

&nbsp;
This is the related document, you can view this content:
Risk Matrix by Profitbase (microsoft.com)
Solved: Creating risk matrix on PowerBI - Microsoft Fabric Community
2022 Week 10 | Power BI: Risk Matrix - Microsoft Fabric Community
Power Bi Risk Matrix with one visual - Microsoft Community Hub
&nbsp;
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Create Risk Matrix

2 Replies

Related content

Creating risk matrix on PowerBI

Async merge risk

I need to create a Risk heat map.

Coloring a risk matrix background

Matrix table