Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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).  ...
  • Ritaf1983's avatar
    2 years ago

    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 words
    after 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-b311f321832c

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