Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I have a report with multiple locations that uses a slicer to switch between each. The locations cannot be combined due to how each location is set up. Is there a way to export all pages from the report to a single document, cycling through each slicer selection automatically and generating a new file for each location?
Example:
Report 1 with 10 pages for location 1
Report 1 with 10 pages for location 2
Report 1 with 10 pages for location 3 .etc.
Thank you,
@Anonymous Why dont you create three bookmarks for all of 3 types of location. On selection of each bookmark, you can export your dashboard to PDF or PowerPoint basis your requirements.
Proud to be a Super User!
Hi Negi007
Thank you for your quick reply and I hope google translate is working accurately.
The locations are not types, they are physical locations. I have more than 90 locations to be exported. My ideal goal is to create a process to export all locations and save the documents with location name with the push of a button or set up a scheduled export and email for each location.
Best,
@Anonymous
I'm afraid that there is no option to change the slicers automatcically while exporting or on the report.
We should submit this as an Idea
Regards,
Manikumar
Proud to be a Super User!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!