Risk Matrix

(0) Share

Report

Posted on by JasonM73

147

Hello all

I am trying to build a risk matrix. I have built the matrix itself using a gallery and made it 5x5 (so 25 choices). I am connected to a SP list in which I have Likelihood and Impact values stored in a couple of records. I would like to plot a dot or x within the corresponding square in the matrix (which would mean a value of likelihood * impact) based on the record. I am very confused as to how to even start this, do I need a collection with all of the permeations in it? Then if so how do I match and only present the X in the right square in the matrix?

Sorry I don't have anything to share to start with as I need to understand what I need to do first

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @JasonM73 ,

My method:

Find a suitable 5 x 5 risk matrix online or create your own one in PowerPoint. Make sure you spend time getting the look of the Risk Matrix exactly how you need
Save the Risk Matrix as an Image
Upload the image into your canvas app and resize/position as appropriate.
Decide on the visual you will use to plot the risk, e.g., a dot, icon or shape. I personally prefer a square shape to wrap around each risk score
Add a text label and size it to exactly match one of the Risk Matrix squares in your image (note it does not have to be a label, you could use a shape or an icon).

You now need to add an expression into your Border Colour property of the label. This is to display an appropriate border colour where the item probability x likelihood is equal to every scenario in a 5x5 configuration. In my example, the expression for this label checks if the selected probability score is 1 and if the selected likelihood score 1. If that condition is met, then the expression will change the border colour of my text label positioned over the 1 square.
Note you do not need apply this logic to the border colour. You could for example apply this logic to the border thickness property (use 0 where the criteria is not met, and anything above 0 where the criteria is met) or the Visible property. Play around with it and see what is most appropriate for your scenario
Duplicate the text property and then position and size it to match to the next square (e.g. for Risk Score 2), then adjust the expression so it applies to that risk score. For a 5x5 configuration you will need to repeat this step to cater for all 25 scenarios.
------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
JasonM73 147 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Amik , will take a look at this shortly. Thank you for the update.

Was this reply helpful? Yes No
JasonM73 147 on at

Like (1)

Report
Copy link

Link copied!

@Amik - Thank so much for this has helped me immensely and I have modified to fit my solution, I simply used an icon with the Visible property set to true or false based on an existing outcome value. Once again thank you

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You're very welcome @JasonM73

Was this reply helpful? Yes No