Forum Discussion
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?
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
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-conditional-color
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18543640-conditional-color-formatting-for-radial-gauge
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.
Regards,
LydiaIt 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.
