Forum Discussion

em101's avatar
em101
Frequent Visitor
2 years ago
Solved

Creating risk matrix on PowerBI

Hi there,  I'm trying to use a data feed of Jira risks (which can be converted into Excel) to then upload into PowerBI to create a risk matrix (project management tool like below). Does anyone know ...
  • giammariam's avatar
    giammariam
    2 years ago

    em101, I apologize for the delay on this. I have attached a .pbix for a possible way to implement the risk matrix. This file contains power query transformations, relationships, measures, and the matrix visual itself.

    You'll definitely need to adjust things but hopefully this is enough to get you going. If so, please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.



  • giammariam's avatar
    giammariam
    2 years ago

    Hi em101. See attached. 

    Here's a relevant link that may be helpful in the future for you related to sorting: Sort one column by another column in Power BI

    If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.



Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello giammariam 

I need to show the number of Issues for each Likelihood and consequence. How do I modify the PBIX file you attached? Please advise! Thanks in advance!