Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
I fixed the issue! It was a problem with the relationships between my datasets.
Hi KM3033,
Please remove the visual , then click Modeling -> Default Summarization-> select Don't summarize. Then create the visual again.
Regards,
Jimmy Tao
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.
I fixed the issue! It was a problem with the relationships between my datasets.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |