Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
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.
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:
Product code | Risk
abc 2
def 10
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:
Supplier name | Risk
Company A 7
Company B 15
I have to plot on a dynamic chart the different combination letting me know to which supplier to 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).
I have tried to use the scatter chart but I cannot find a solution.
Thank you in advance.
Solved! Go to Solution.
Hi @isabella2003199,
Since there is no relationship between above two tables, you can combine them via CrossJoin.
Cross Table = ADDCOLUMNS ( CROSSJOIN ( 'Product Table', 'Supplier Table' ), "Total risk", 'Product Table'[Risk in product] + 'Supplier Table'[Risk in supplier] )
Then, you can insert a matrix visual to display data. Besides, if you want to highlight the high risk combination, you can enable "Conditional formatting" option.
Best regards,
Yuliana Gu
Hi @isabella2003199,
Since there is no relationship between above two tables, you can combine them via CrossJoin.
Cross Table = ADDCOLUMNS ( CROSSJOIN ( 'Product Table', 'Supplier Table' ), "Total risk", 'Product Table'[Risk in product] + 'Supplier Table'[Risk in supplier] )
Then, you can insert a matrix visual to display data. Besides, if you want to highlight the high risk combination, you can enable "Conditional formatting" option.
Best regards,
Yuliana Gu
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |