Forum Discussion

emma313823's avatar
emma313823
Helper V
2 years ago
Solved

Modifying gauge visual

All,   I'm wondering if there is a way to accomplish this in a gauge visual. I'm using the following measure for a gauge visual and have 8  - each filtered to a specific cutomer we are monitoring. ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi emma313823 

     

    Sorry for not ending clearly.

    I corrected Measure for you:

     

    Prcnt-to-Frcst =
VAR SumActual =
    CALCULATE ( SUM ( 'Forecast-v-Actual'[Actual] ) )
VAR SumForecast =
    CALCULATE ( SUM ( 'Forecast-v-Actual'[Forecast] ) )
RETURN
    FORMAT ( DIVIDE ( SumActual, SumForecast, 0 ), "Percent" )

     

     Then you can put the Prcnt-to-Frcst measure in the Callout value box, just as the Percentage measure in my side.

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi emma313823 

 

Please try this:
Here I create a set of sample:

Then add a Gauge visual:

You can open the Custom label in the Callout value pane and select the percentage to the box:

Here is the result:

 

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.