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. Try updating the measure to the following:

_issueKeyConCat = 
var newLine =
"
"
var issueKey = SELECTEDVALUE(Jira[Issue Key], CONCATENATEX(Jira, Jira[Issue Key], newLine))
var result = SWITCH(
    true,
    ISBLANK(issueKey), "",
    issueKey
)
RETURN result

 
Also, you will need to adjust the matrix dimensions and probably the font size for the matrix values to get everything to fit.

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

    giammariam thanks so much, that seemed to largely work. I'm just sending you a direct message as I have almost got it to work just one more small query. Thanks