KPI with Gauge visual

[MP_123]

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

[Anonymous]

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

[Alosat]

Can one setup this with 3 colors?

[v-haibl-msft]

@MP_123

Have you tried with Bullet Chart? I used Bullet Chart and KPI Indicator in following report.

Best Regards,

Herbert

[MP_123]

@v-haibl-msft

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 · Accepted solution]

@MP_123

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

[MP_123]

@v-haibl-msft

thanks you!

actually i've notice that there is a meaning to the order you add the columns into the visual.. strange

thanks again

[v-haibl-msft]

@MP_123

If your problem has been solved, could you please mark the correct answer to close this thread?

If you found some issues related to DialGauge, you can try to contact author.

Best Regards,

Herbert

[MP_123]

@v-haibl-msft

there is no option to change the colors? |:

thanks!