Radial Gauge

[Anonymous]

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.

[v-juanli-msft · Accepted solution]

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]

Awesome - I think it was the relationship setup.

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

[v-juanli-msft]

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]

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