Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have created a risk matrix using matrix visualization as shown below, where (I) shows impact and (P) shows probability.
The values are the count of risks
Value | Low (I) | Medium(I) | High(I) | Very High(I) |
Low (P) | 79 | 43 | 22 | 45 |
Medium(P) | 30 | 11 | 32 | 113 |
High(P) | 5 | 53 | 90 | 67 |
Very High(P) | 4 | 21 | 19 | 16 |
My expectation is to show it as below using the background color.
Is there any workaround to do this?
Would appreciate your response.
Thanks.
Solved! Go to Solution.
@Pratz203 hello,
The Table and Matrix controls have the "Conditional Formatting" option, you can color the background based on defined rules.
I leave the url with the information:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Thanks for your response.
But my background formatting is independent on the value. The background color should be fixed.
You can try also row header property.
You can use conditional formatting.
Refer the below thread :
https://community.powerbi.com/t5/Desktop/Matrix-Background-Color-Coding/m-p/891894
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |