Forum Discussion
Gauge Chart Colour Formatting From Measure
- 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 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.
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 :
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.
Hi!
I wrote the dax but in the What field should we base this on? I am not able to select the measure. Do you know want can be the reason? Thanks so much for your help!!