Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
GAPER
Helper V
Helper V

Tree Diagram Configuration.

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

 

GAPER_0-1698972694045.png

GAPER_1-1698972706676.png

 

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

 

GAPER_3-1698972831152.png

 

GAPER_2-1698972770423.png

 

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?

2 REPLIES 2
GAPER
Helper V
Helper V

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

amitchandak
Super User
Super User

@GAPER , 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

amitchandak_0-1698979825324.png

 

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

 

amitchandak_1-1698979868800.png

 

 

 

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.