Forum Discussion
I need to create a Risk heat map.
- 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
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.
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.