Forum Discussion
I need to create a Risk heat map.
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
Visual: Matrix
Rows: Likelihood
Columns: Impact
Values: Count/FirstName of Risk ID
Step 5: Apply Conditional Formatting
To color cells based on the severity, do this:
Click the Values section in the Matrix
Click the dropdown → Conditional Formatting → Background color
Choose Rules
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.
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.
Is this relationship is correct? because i am getting same output
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.