Power BI Treemap with Conditional Formatting

[ben73]

Hi All,

I need to fulfil the business requirement: building a progress chart using treemap that the color of the bars can change based on certain value (In this case is measure 'A'). I have tried to implement the Advanced Controls but it didn't get me anywhere. Please kindly need your help.

[v-kongfanf-msft · Accepted solution]

Hi @ben73 ,

You can try below formula and use it in conditional formatting:

TreemapColor = 
SWITCH(
    TRUE(),
    [Measure A] < 75, "Blue",
    [Measure A] >= 75, "light blue",
    "Gray"
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ben73]

Hi @v-kongfanf-msft ,

Thank you for your reply. I decided to use Data bar KPI visual published by Travis Sansome to solve my problem. Maybe next time, I will try your solution.