Forum Discussion
In matrix value background changes based on row header
Hello,
I would like to have a matrix where all backgrounds of values are in different color based on row header (in my case - Region). I have tried to do it, however, not all backgrounds are changing. Please see below:
The formula:
And then rules:
Can sombedy help me and answer where is the mistake.
Thank you:)
Erburi92 , Create a measure that returns the color of the hex code
Switch( Max(Table[Region Code]),
"Africa", "Green" ,
"America", "#FF00F0" ,
// Add other
)
Use this in conditional formatting using the field value option
But in matrix, it will only color values (Not row and column)
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
1 Reply
Erburi92 , Create a measure that returns the color of the hex code
Switch( Max(Table[Region Code]),
"Africa", "Green" ,
"America", "#FF00F0" ,
// Add other
)
Use this in conditional formatting using the field value option
But in matrix, it will only color values (Not row and column)
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3