Forum Discussion
Report Printing with Slicers
Hi guys, I created a report that has a slicer that filters my visualizations by the selection of the slicer. I would like to print my report with separate pages for all of the possible selections of the slicer. To clarify, my report has 2 pages and the slicer has 8 different options to select from. I would like to be able to print the 2 page report for all 8 companies in one shot. Anyone who knows how to do this or has a workaround please respond!
4 Replies
- edhans
Community Champion
You cannot do this in Power BI. Your best option might be to use Analyze in Excel to pull the data down, then use VBA to cycle through the values in the filter. How to generate a PDF for each value in a filter? - Microsoft Community Hub
But that wouldn't be ideal.Thank you for the response. It seems like you're saying there is no simple workaround in Power BI to print based on the slicer.
Can you elaborate on what the process would be to analyze the data in excel and then use VBA to cycle through the slicer?
Also, my report is set up so that my company can cycle through the different companies by selecting one from the slicer. This way they can have a report that doesn't have a bunch of slides. How would you accomplish this if you were building the report? Is there a way to still retain a easy filtering process that Power BI will be able to print based on all the options?
Thanks again!
- edhans
You would bring in the data using analyze in Excel. The slicer values would be put in a filter in the Excel pivot table.
Then you'd need to read the thread I linked to above that shows how to write the VBA code to cycle through the filter items. If you need more help with VBA, an Excel/Office forum would be the place.
Thank you for your help!
