Conditional Formating for color of the Guage
conditional formatting of Color of the gauge to change on the basis of value
6-20 = yellow
>20 = Red
Lauren Solo commented
It surprising to me that this isn't a standard function. There should be an option to color the gauge. Makes the visual useless in my opinion.
I support the conditional formatting on any bar or gauge
Edward Horne commented
Yes, this please!!!!!
I'd like to be able to use this for % sales to plan. That is, if our YTD performance is >= 100%, then show green. If it's >= 95% and <100%, then show yellow. If <95%, then show red. This is a really common use case and I'm struggling to simply show % to plan, with color coding. This should be simple. Thanks!
David Cornwell commented
Absolutely need this.
The thresholds should be able to be set based on measures in the data and not hard coded in the gauge controls, so that goals can be set in the database that may change and the conditional formatting would change based on the goals changing.
Conditional formatting relative to the target would be great.
I would like the option to have a red color if the value is below the target and green when it's above the target. Also the ability to choose high is better or low is better so that the colors will be the other way around.