Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
User | Count |
---|---|
94 | |
89 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |