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.
I have a report that has about 10-15 visuals and a slicer with about 15 values on MSIT.powerbi.com. I started observing performance issues with the report and I moved the slicers to report level filters. With this change I got about 40 - 45% improvement in performance. I wanted to check if there is something incorrect in the way I have designed my report or do slicers impact report performance to that extent?
Well, a slicer is going to cause a dynamic query to take place for each visual versus a single filtering of the underlying data.
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |