Gauge Visual Auto-Aggregating

[KM3033]

Hi everyone,

I'm having trouble with my gauge visual--it's automatically aggregating the "max value" and "target value" fields. The visual is on a report that has a slicer for each region (e.g. "Texas", "New York City"). Ideally, the gauge would only show the individual region's target / max value, but it's aggregated all of the region's values together and doesn't separate based on what's selected on the slicer.

Is there a way to turn off the aggregation? I have another tab with territories (there's about 7 territories compared to 20+ regions) and the gauge works exactly as I want it to and doesn't automatically aggregate.

Thanks!

[v-yuta-msft]

 Hi KM3033,

Please remove the visual , then click Modeling -> Default Summarization-> select Don't summarize. Then create the visual again.

Regards,

Jimmy Tao

[KM3033]

Hi @v-yuta-msft,

I went to try your solution, but my default summarization was already at "Don't summarize". I still deleted the visual and re-created it, but ran into the same problem.

[KM3033 · Accepted solution]

I fixed the issue! It was a problem with the relationships between my datasets.