Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Zilvinas
New Member

Gauge changing color

Hi, 

 

Is there any change to be able to change Gauge color by the value? Let's say if the value is below target it is red, if it's on target then yellow if above then green? 

asdasda.PNG

Just to go further, I have already tried tachometer. But there is a problem as tachometer needs a lot of space to be able to show current value and target. Or there is a way to make them smaller but keep the values?

 

2 REPLIES 2
ColinB
New Member

It is possible to do this with Gauge. You have to create an additional measure that divides actual by budget and then use that measure as your "based on field" in conditional formatting.

SNip.PNG

v-yuezhe-msft
Employee
Employee

@Zilvinas ,

Currently, it is not possible to change Gauge color by the value, there are some ideas about this issue, please vote them up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33451771-gauge-chart-with-conditi...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18543640-conditional-color-format...

In your scenairo, please use tachometer as a workaround. And to make tachometer smaller, you can change text size of values/data labels to  the smallest value under formatting setting.
1.PNG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.