Tree Diagram Configuration.

[Anonymous]

I noticed that there is a option to use function to determin the color of the boxes (IF I DON'T PUT DETAILS)

however once i put details in. The colors is fixed which I can't change using a formular. 

My goal is to have the groupping like case 2. But also having the flexbility to dynamically determine the coloring like case 1. Anyone knows what to do about this?

[Anonymous]

How do you have the cells that from the same brand close to each other. 

[amitchandak]

@Anonymous , Power Bi conditional formatting is not supported with once you use details in tree map.

Move both of them  category expand and the use conditional formatting

color on brand has been used with help measure and field value formatting

Brand Color = Switch( true(),
max('Item'[brand]) = "Brand 1" , "red",
max('Item'[brand]) = "Brand 2" , "blue",
max('Item'[brand]) = "Brand 3" , "green",
max('Item'[brand]) = "Brand 4" , "gray",
max('Item'[brand]) = "Brand 5" , "yellow",
max('Item'[brand]) = "Brand 6" , "orange",
max('Item'[brand]) = "Brand 7" , "brown",
max('Item'[brand]) = "Brand 8" , "Cyan",
max('Item'[brand]) = "Brand 9" , "Tan",
max('Item'[brand]) = "Brand 10" , "Violet",
max('Item'[brand]) = "Brand 11" , "Gold",
"silver"
)

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