Forum Discussion

ben73's avatar
ben73
Frequent Visitor
2 years ago
Solved

Power BI Treemap with Conditional Formatting

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    ben73
    Frequent Visitor
    2 years ago

    Hi Anonymous ,

     

    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.