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