In matrix value background changes based on row header

[Erburi92]

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:)

[amitchandak · Accepted solution]

@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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...