Forum Discussion
KPI with Gauge visual
hi all
i want to apply a kpi visual, changing colors according to target(reg\green)
the kpi is percentage (one value, for example 6%)
target value is 50%
i don't want the kpi visual (like card visual) but gauge visual
the problem that guage doesn't change it's color according to values... and i don't understand how to use the dial gauge visual since i don't have max\min or start\end values.
is someone have an idea how to create an intersting KPI visual?
thanks a lot
If you’d like the dial gauge visual, you can try as below with two values of “Target Value” and “Current Value”.
Best Regards,
Herbert
8 Replies
- v-haibl-msft
Microsoft Employee
Have you tried with Bullet Chart? I used Bullet Chart and KPI Indicator in following report.
Best Regards,
Herbert
- MP_123
Microsoft Employee
hi Herbert, thanks!
it's a good soloution but i really prefer gauge to my design.
i just don't know how to use the dial gauge (saw explanation movie) but the visual doesn't behave as exxpected....
if someone used this visual i will be happy for help!
thanks!!
- v-haibl-msft
Microsoft Employee
If you’d like the dial gauge visual, you can try as below with two values of “Target Value” and “Current Value”.
Best Regards,
Herbert
- AlosatFrequent Visitor
Can one setup this with 3 colors?
- AnonymousNot applicable
To create a Gauge that dynamically changes colour based on the current value use conditional formatting.
To learn how, check out the YouTube demo: https://youtu.be/oEL36Fp3TU0