Forum Discussion
Multiple Guage Colors Base On Status
So I am looking to create a guage that uses multiple colors based on a given status in the data. For instance we have a goal and I want to display the teams progress. So we have one value as "Achie...
HiAnonymous，
you can try to create a measure like this：
Gauge Color =
SWITCH ( TRUE (), [Reserved] > ValueA, "Green", [Achieved] > ValueB, "Red" )
Then you can use this DAX measure in the conditional formatting, this time, you need to select Format by Field Value, and then select the Gauge Color measure here.
For more information，you can refer to this article ：
https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.