Forum Discussion
PBI Tree Map Color Mapping
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?
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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
2 Replies
- amitchandak
Super User
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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3 
_AAndradeResident Rockstar
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