Forum Discussion
Coloring a risk matrix background
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.
6 Replies
- mwegenerMost Valuable Professional
- Tahreem24Super User
You can use conditional formatting.
Refer the below thread :
https://community.powerbi.com/t5/Desktop/Matrix-Background-Color-Coding/m-p/891894
- mwegenerMost Valuable Professional
- AnonymousNot applicable
Thanks for your response.
But my background formatting is independent on the value. The background color should be fixed.- Tahreem24Super User
You can try also row header property.
- DR_GTNew Member
@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