Guage with three colors

[Dunner2020]

Hi there,

I am looking for to have three colors in 'guage' visual in such a way that that upto 50% of guage, it shows green color, from 50% to 85% it shows yellow and remaining portion it shows red. I looked into guage properties but did not come across anyone. Is there any way of including three colors in guage?

[Anonymous · Accepted solution]

Hi @Dunner2020 

You can set conditional formatting for Data colors .

Original data :

Then create a column to judge which interval the value is in .

Column = SWITCH(true(),'Table'[Value]=0.5,"green",'Table'[Value]>0.5 && 'Table'[Value]<0.85,"yellow","red")

Add the gauge visual ,then put the column in Fill in Data colors .

The final result is as shown :

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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