Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
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.