How to generate PDF of all pages for slicer?

[Anonymous]

Hello

How to automatically generate PDF pages of all the slicer selected options in my dashboard? I have a list in the slicer but i want to generate a page for each slicer option selected. Is this possible? I have premium license. Maybe use Power Automate to do this?

[VahidDM]

Hi @Anonymous 

Check this link: 

How to add a button to the Power BI report for sending a PDF of the report to the User Email

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[parry2k]

@Anonymous Yes you can achieve this using Power Automate, iterate over slicer value and then export to pdf.  This document can get you started, Export and email a report with Power Automate - Power BI | Microsoft Docs

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Anonymous]

@parry2k Thank you for your reply!

I have followed the guide that you suggested and i managed to get the Power BI report exported as PDF and sent to me as attachment in an email. But it is not able to iterate through the slicer values. It only sends me the pages of the report. There are 3 pages in all and the slicer is on the second page. I would like to have the PDF file contain all the pages, so first page, and all slicer options (14 in total) for second page and third page. So, the final generated PDF file should have 16 pages. Could you please advise how to proceed?

This is the "Export To File for Power BI Reports" step but i don't know if it is necessary to configure this part or how to do it? And for the iteration, i assume there is some loop involved but i don't know how to build it so that it takes into account the slicer index/value. Any help is much appreciated!

[arpitbhardwaj]

Hi,

Were you able to solve this?