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.
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?
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.
@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.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |