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.



giammariam's avatar
giammariam
Solution Sage
2 years ago

Hi em101, apologies for the delay. In the first Merged Queries step I'm joining on [Residual Likelihood] (Jira query) to [Likelihood] (Likelihood query). Then in the subsequent Expanded Likelihood step, I'm bringing the [Likelihood Number] field into the Jira query.


The same pattern exists for bringing in the Consequence Number.

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.



  • em101's avatar
    em101
    Frequent Visitor
    2 years ago

    Hi giammariam 

    Thanks so much for clarifying the Merge and Expand steps. When I entered in the same IssueKeyConCat DAX formula to the one you used (I changed it to refer to Jira2 Query data not your original Jira Query), I seem to get the below error message on the Risk Matrix visual. I'm trying to work with about 60 rows of risks this time. Do you know what I might be doing wrong with the DAX? Thank you.