Select pages to Export

[NAOS]

Hi all,

I am trying to achieve the following:

From a list of multiple projects, I want users to be able to export .pdf and .pptx files where each page corresponds to one project and its correspondant information.

For this I've set up a report where the first page looks like this:



Each of the slicers is connected to one hidden page. The slicers all come from the same table-column, Projects-Project Name, so the user selects one project per slicer, therefore populating each hidden page with the data correspondant to its selected project. It works perfectly fine if all slicers (and therefore their pages) have a value ( I havent tried this with the 24 projects, only with up to 4 and it works ok).

The problem is with the slicers / pages that do not get a value, which is what happens in most cases.

I would like to be able to further control which pages get exported. I could make them blank if the sync slicer has nothing selected, but then the users would have to manually delete the slides in their .pptx or remove the pages on their pdf afterwards.

Does anyone have an idea on how to go around this? I could make all the pages visible if necessary. May be there is a "dynamically hide pages" option that Im not aware of? Or something that allows me to export a certain number of pages?

Any idea is welcome. So let's get creative! haha

Thanks in advance to everyone that takes on this challenge.

[v-yuta-msft]

@NAOS ,

I'm afraid currently 'dynamically hide pages' as you mentioned are not supported in power bi. I would suggest you to post your idea here.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NAOS]

Up up!

[v-yuta-msft]

@NAOS ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[NAOS · Accepted solution]

Hi!

Not really, no. There are no ideas similar to this thread in the Ideas portal and I've opted to use a custom solution that does not include PBI, unfortunately...

Thanks anyway!