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 to implement the Advanced Controls but it didn't get me anywhere. Please kindly need your help.

 

 

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.

     

2 Replies

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