Create Risk Matrix

[gojets1721]

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 solution]

Hi  @gojets1721 ,

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])

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

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.

[DataInsights]

@gojets1721,

Here's a visuals reference that should help you choose the optimal visual. Check out the Correlation visuals.

https://www.sqlbi.com/ref/power-bi-visuals-reference/