Forum Discussion

Manikanta2108's avatar
Manikanta2108
Helper I
1 year ago
Solved

I need to create a Risk heat map.

I want to create a Heat Map as shown in below figure with same background colours. I am having Values for Likelihood(4 and 5) and Impact(3, 4 and 5). And in the cells in need to show the count of Ris...
Need Help
Show and Tell
  • ajaybabuinturi's avatar
    ajaybabuinturi
    1 year ago

    Hi Manikanta2108,

    I have created a sample report with heat map. Using/Referring this report you can achieve your requirement. Please follow the steps to achieve.
    Step1: I hope you have data of Risk ID, Likelihood and Impact.
    Step2:     Create a measures for Risk Score & Risk Severity.

    Risk Score = SELECTEDVALUE('Table'[Likelihood]) * SELECTEDVALUE('Table'[Impact])
Risk Severity = 
VAR Score = [Risk Score] // SELECTEDVALUE('Table'[Likelihood]) * SELECTEDVALUE('Table'[Impact])
RETURN
    SWITCH(
        TRUE(),
        Score >= 20, "Critical",
        Score >= 12, "High",
        Score >= 6, "Medium",
        Score >= 3, "Low",
        "Informational"
    )

    Step3: Create a Matrix Visual

    1. Visual: Matrix

    2. Rows: Likelihood

    3. Columns: Impact

    4. Values: Count/FirstName of Risk ID

    Step 5: Apply Conditional Formatting

    To color cells based on the severity, do this:

    1. Click the Values section in the Matrix

    2. Click the dropdown → Conditional Formatting → Background color

    3. Choose Rules

    4. Set up rules based on Risk Score

    I am also attching a .pbix file for you refreence. 

    https://drive.google.com/file/d/1DiZcWDQujOa9NaU-ehzQuyiQjcc4FuHA/view?usp=sharing 

     

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

     

     

     

     

     

     

     

speedramps's avatar
speedramps
Super User
1 year ago

Try this

Create some test data

Create a dax measure, but use your own colour bandings

RAG = 
var myscrore = SUM(yourdata[Score])
RETURN
SWITCH(TRUE(),
myscrore <3, "Green",
myscrore <6, "YelloW",
"Red"
)

 

Draw a matrix visual

 

In conditional formating select "Field Value" and specify your DAX name

 

It works !  So please click thumbs up and the [accept solution] button. Thank you