cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NAOS Member
Member

Select pages to Export

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:

FirstPage.PNG

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
NAOS Member
Member

Re: Select pages to Export

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!

View solution in original post

4 REPLIES 4
NAOS Member
Member

Re: Select pages to Export

Up up!

Community Support Team
Community Support Team

Re: Select pages to Export

@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.

Community Support Team
Community Support Team

Re: Select pages to Export

@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 Member
Member

Re: Select pages to Export

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!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 177 members 1,937 guests
Please welcome our newest community members: