I need to create a Risk heat map.

[Manikanta2108]

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 Risk ID.

[v-venuppu]

Hi @Manikanta2108 ,

I want to check if you had the opportunity to review the information provided and resolve the issue. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @Manikanta2108 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @ajaybabuinturi @speedramps for the prompt response.

I have replicated the scenario using sample data, please go through the attached pbix file, hope this helps.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[ajaybabuinturi · Accepted solution]

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.

[Manikanta2108]

Hi @ajaybabuinturi the background colour is applying for Count of risk ID facing issue for background colors

Its not coming properly.

[Manikanta2108]

Currently, I am having only values for Impact is 3 and 4 and for likelihood i am having 3, 4 and 5. I don't have data for 1 ,2 and 3 values i need to show empty data but need background colurs for 1,2 and 3 values as shown in below figure

[ajaybabuinturi]

@Manikanta2108 Could you please provide some sample data

[Manikanta2108]

Hi @ajaybabuinturi 

This the sample data set i have and i need to create risk heat map like below picture with same background and need to show Count of riskid as values in cells.

[ajaybabuinturi]

@Manikanta2108 

To get rows (Likelihood) and columns (Impact) from 1 to 5. 

1. Need to create a separate dimension table for Likelihood and Impact as below.

ImpactTable = GENERATESERIES(1, 5, 1)
LikelihoodTable = GENERATESERIES(1, 5, 1)

2. Then create relationships:

Table (2)[Impact] → ImpactTable[Value]

Table (2)[Likelihood] → LikelihoodTable[Value]

3. Enable show items with no data for rows and columns.

Power BI will now show all 1–5 combinations, even those with no matching RiskID and you can still apply conditional formatting based on calculated scores.

4. Apply your conditional formating using measure or rules.

5. You can follow the remaing steps mentioned in previous response.

https://drive.google.com/file/d/1uHRtMiL1AqPOFcBmQV6LWZrREYwwG7Fh/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.

[Manikanta2108]

Is this relationship is correct? because i am getting same output

[ajaybabuinturi]

Hi @Manikanta2108, 

Did you refer attached file?

It's correct but you need use dimtables as columns and rows. 

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]

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