Forum Discussion
Gauge Chart Colour Formatting From Measure
I'm trying to format a Gauge display so that the bar colour updates depending wether it is more than, equal to or less than a target that increases each week (ideally with margins either side). ...
Hi Anonymous
You nee the measure that returns the wanted color based on the value of the actual according to the target.
I made a small example to show how it works.
I didn't understand the "yellow" condition so it based 2 others.
The condition should be like :color format = IF([act]>=[target_]*1.05,"red",IF([act]<=[target_]*0.95,"blue"))The measure could be with hex codes instead the wordsafter you have this measure you can take it to conditional formatting at the gauge:
result:
I used blue instead of green because is not recommended in ux .
Colorblind people don't see the difference :
https://uxdesign.cc/from-a-colourblind-designer-to-the-world-please-stop-using-red-and-green-together-b311f321832cpbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you this worked perfectly. For the "yellow" part i managed it with an AND for the range of values.
*colourFormatTotal = SWITCH(
TRUE(),
[*minutesLost] <= [*runningDtTargetTotal]*0.95, "#2C9400",
[*minutesLost] >= [*runningDtTargetTotal]*1.05, "#C00000",
[*minutesLost] <= [*runningDtTargetTotal]*1.05 && [*minutesLost] >= [*runningDtTargetTotal]*0.95, "#E8CF55",
"null"
)