Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

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

  • 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

8 Replies

    • MP_123's avatar
      MP_123
      Icon for Microsoft Employee rankMicrosoft Employee

      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's avatar
        v-haibl-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        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

  • Anonymous's avatar
    Anonymous
    Not 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