cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NAOS Regular Visitor
Regular Visitor

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 Regular Visitor
Regular Visitor

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!

4 REPLIES 4
NAOS Regular Visitor
Regular Visitor

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 Regular Visitor
Regular Visitor

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!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 39 members 964 guests
Please welcome our newest community members: