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...
Hi Anonymous ,
What do you mean by different colours on the same gauge you want to select the values (achieved / reserverd) from a slicer and the gauge change colours? you want to have both of them in the same gauge at the same time?
Can you share a sample of your data and expected result.
If you want to usea slicere you can use a condittional formatting something similar to:
Colour = SWITCH(SELECTEDVALUE('Table (2)'[Satus]) , "Actual", "Green", "Reserverd", "Blue", "Grey")
See PBIX file attach, the condittional formatting can also be applied to the target line.