Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Radial Gauge

I've created a dashboard which details YTD figures. It includes a Radial Gauge. The issue I have is that the MAX Value is always detailing the SUM TOTAL of all Business Units - while the gauge meter updates according to each Business Unit's progress. I need the MAX Value to update for each Business Unit - and not detail the TOTAL.

 

See the attached screenshot.

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    As tested, it works on my side.

     

    Please check if the Radial Gauge is filtered or ignored by the slicer( check the Format->Edit interactions)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    If "business unit" and MAX Value are in the same table, it should work for the max value in a Radial Gauge to change with the slicer.

    Please share some example data so i can reproduce your problem.

     

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    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
      6 years ago

      Hi Maggie,

      Here's the data that should be reflected per Business Unit (as the MAX Value) each time a different Business Unit is selected. Again, currently, the Max Value only reflects the GRAND TOTAL for all units ALWAYS.

       

      PlowShare - US: 0
      Maxcess - US: 0 
      Publicis Resolute - UK: 0 
      Verilogue - US: 0
      Real Science - UK: 0
      Saatchi Wellness - US: € 6,493,802
      insync - US/Canada: 0
      Publicis LifeBrands Medicus - Japan: 0
      Publicis Health - France: 0
      Publicis Health Media - US: € 6,764,377
      Saatchi Wellness - UK: 0
      Razorfish Health - US: € 3,156,709
      Saatchi Wellness - Japan: 0
      Publicis LifeBrands London - UK: 0
      Digitas Health - US: € 6,899,665
      Digitas Health - UK: 0
      Heartbeat - US: 0
      PH Corporate: 0
      Langland - UK: 0
      Payer Sciences: 0
      Publicis Health.Sapient - US: 0
      Langland - US: 0
      Publicis Groupe: 0

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    As tested, it works on my side.

     

    Please check if the Radial Gauge is filtered or ignored by the slicer( check the Format->Edit interactions)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    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
      6 years ago

      Awesome - I think it was the relationship setup.

      I was able to get what I needed. Thank you!