Risk matrix chart in Power BI

Question

Hi everyone,&nbsp;I am using Power BI desktop. I have to produce a risk matrix allowing me to combine different values once having filtered by two slicers.&nbsp;I mean, I have different products with a unique code, each product has an instrinsic risk due to the complexity of its production. So for example I have a table like this:&nbsp;Product code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Riskabc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2def&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10&nbsp;Then, I have different Suppliers that in the same way have an instrinsic risk due to their way of producing products, their reliability and so on.. having a table like this:&nbsp;Supplier name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RiskCompany A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7Company B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;I have to plot on a dynamic chart the different combination letting me know to which supplier to&nbsp;assign a product code having the lowest combined risk (for example by checking with slicers I can give the abc product to company b while I cannot do the same with product def since the resulting risk combination will be too high).&nbsp;I have tried to use the scatter chart but I cannot find a solution.&nbsp;Thank you in advance.&nbsp;&nbsp;&nbsp;

v-yulgu-msft · Accepted Answer

Hi&nbsp;isabella2003199,
&nbsp;
Since there is no relationship between above two tables, you can combine&nbsp;them via CrossJoin.
Cross Table =
ADDCOLUMNS (
    CROSSJOIN ( 'Product Table', 'Supplier Table' ),
    "Total risk", 'Product Table'[Risk in product] + 'Supplier Table'[Risk in supplier]
)

&nbsp;
Then, you can insert a matrix visual to display data. Besides, if you want to highlight the high risk&nbsp;combination, you can enable "Conditional formatting" option.

&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

Risk matrix chart in Power BI

1 Reply

Related content

Power Matrix visual

Power BI Chart - Matrix Chart

Power BI Matrix

Matrix table in Power bi

alternative chart power bi