Forum Discussion
In matrix value background changes based on row header
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
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