Build an Interactive Risk Matrix in Power BI (Button Slicer Technique)

[@gavinwilkes9401]

Great video, thank you!

[@user-um6cu9hg8u]

Sir I am your fan!!

[@jasondavidsondata]

Thanks 😊 appreciate your kind words!

[@farmaccount5923]

I am having problems seeing the data I imported. I have the slicer and the risk matrix created. When I click a button no data displays from my source. Do you have any tips?

[@VinayNair]

Awesome tutorial. Thank you, @Jason Davidson ! I have now used this for my portfolio projects. One question: When we select a risk on the right hand table, the slicer gets rearranged to show just the risk value for that selected risk. Any way we can fix the slicer to not change position?

[@jasondavidsondata]

Yes, you can add a +0 to the end of the measure that count the number of risks. This way even if there are no risks in a certain square, it will return a 0 value.

[@DoMusafirCanada]

I am getting an extra grid when selecting the post mitigation column. So ideally it is a 5 by 5 matrix but an extra grid in the row is making it a 6 by 5 matrix. Any solution to this problem? Thanks!

[@jasondavidsondata]

Off the top of my head it could be a few things. 1.) You have a blank value for a risk ranking. 2.) Your have 26 unique values, instead of 25. In the values assigned to each work order. Hope that points you in the right direction.