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.
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.
- Manikanta21081 year agoHelper I
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
- ajaybabuinturi1 year agoSuper User
Manikanta2108 Could you please provide some sample data
- Manikanta21081 year agoHelper I
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.
- Manikanta21081 year agoHelper I
Hi ajaybabuinturi the background colour is applying for Count of risk ID facing issue for background colors
Its not coming properly.