Forum Discussion

KM3033's avatar
KM3033
Frequent Visitor
8 years ago
Solved

Gauge Visual Auto-Aggregating

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!

Need Help
  • KM3033's avatar
    KM3033
    8 years ago

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

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

     Hi KM3033,

     

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

     

    Regards,

    Jimmy Tao

    • KM3033's avatar
      KM3033
      Frequent Visitor
      8 years ago

      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's avatar
        KM3033
        Frequent Visitor
        8 years ago

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