PBI Tree Map Color Mapping

[EricH77]

I have created a tree map in PBI and the layout looks exactly how I need it to look but the visual colors are not what I need.  I need to only use a color scheme consisting of Red, Yellow, Green, and Gray based on the corresponding Health Indictor field which uses the text Red, Yellow, Green, and Gray.  To achieve this, I need PBI to base the colors on the details field (Health Indictor).  However, it appears that be defualt it is selecting the category field (Client Code).  I can't swap the inputs to these fields because it completely changes the layout.  Is there anyway to change what field PBI uses for the visual color scheme?

[_AAndrade]

Hi,

I think it's not possible to do as you want, but you can probably work around it doing this:
Classify your clients by Health Indicator and after create a measure to select the color you want by health indicator and put this measure on "Colors"-->Advanced controls

[amitchandak · Accepted solution]

@EricH77 , if you have details, you will not be able to use conditional formatting. If you are looking for that. Move both columns to Category and the create a color measure and use that in color using Fx option

example

Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)

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...