Forum Discussion
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 Risk ID.
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.
11 Replies
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
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.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
Manikanta2108 Could you please provide some sample data
Hi ajaybabuinturi the background colour is applying for Count of risk ID facing issue for background colors
Its not coming properly.
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. 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.
