cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tatmel Frequent Visitor
Frequent Visitor

Slice filter doesnt apply to Export to PowerPoint

Hi All,

 

I faced with following issue by trying to export my data to PowerPoint from powerbi.com

 

My report consists with 10 pages. On each of the page I am using different slicers for filtering my data in the visuals.

When I am trying to export filtered by slicers report to Power Point, it generates file where the visuals are represent data without any filters. It makes such export useless for presentation.

 

Please have a look and share your experience with that.

 

Kind regards,

 

Tatiana

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-haibl-msft Super Contributor
Super Contributor

Re: Slice filter doesnt apply to Export to PowerPoint

@Tatmel

 

I cannot repro the same issue on my side. The exported PPT can retain the slicer selection and data is filtered in the visual. Please refer to the video below and let me know if there is any difference between our repro steps. Please make sure that you've saved your report after you select something in the slicer.

 

BTW, In-session interactivity such as highlighting and filtering, drill-down, and so on, are not yet supported when exporting to PowerPoint. The exported PowerPoint shows the original visuals as they were saved in the report.

 

 

Best Regards,
Herbert

15 REPLIES 15
v-haibl-msft Super Contributor
Super Contributor

Re: Slice filter doesnt apply to Export to PowerPoint

@Tatmel

 

I cannot repro the same issue on my side. The exported PPT can retain the slicer selection and data is filtered in the visual. Please refer to the video below and let me know if there is any difference between our repro steps. Please make sure that you've saved your report after you select something in the slicer.

 

BTW, In-session interactivity such as highlighting and filtering, drill-down, and so on, are not yet supported when exporting to PowerPoint. The exported PowerPoint shows the original visuals as they were saved in the report.

 

 

Best Regards,
Herbert

Vicky_Song Established Member
Established Member

Re: Slice filter doesnt apply to Export to PowerPoint - Status changed to: Needs Info

 
Superdelucs Frequent Visitor
Frequent Visitor

Re: Slice filter doesnt apply to Export to PowerPoint

The same issue when exporting data to Excel from both the cloud as Power BI Desktop. All my filters are overruled by the export function, while the pop-up screen tells me all filters are kept. 

Tatmel Frequent Visitor
Frequent Visitor

Re: Slice filter doesnt apply to Export to PowerPoint

Hi Herbert,

 

It works fine now! My issue was that I didn't save the report before I sent it to PowerPoint!Smiley Happy

 

Thank you for the solution!!!

 

Kind regards,

 

Tatiana

pbigeek_ac Frequent Visitor
Frequent Visitor

Re: Slice filter doesnt apply to Export to PowerPoint

@Tatmel -thanks for posting this issue. This is something I am also facing and solution provided by @v-haibl-msft is flawless.

 

However, this leads to another issue which I encountered recently. My PBI reports do not have filters inside the report body (unlike the video was shown by @v-haibl-msft )and we control data filters based on the right-hand side ribbon based Report Level Filter.

 

Does PPT extract behave the same way with this filter too? If not, what is the workaround to this? Also, these reports are built using PBI Desktop client and published. I don't see any "Save" button after applying the filter but "Save As" button is there. What I'm missing here?

laurajj419 Visitor
Visitor

Re: Slice filter doesnt apply to Export to PowerPoint

There is new functionality in PowerBI, so this works now:

 

First, apply your desired filters to the report.  Then, create a bookmark.  Next, go to Reading View and view that bookmark.  Finally, export to PowerPoint.  When you export to PowerPoint, it will export that bookmarked view with filters applied.

ManuelaMonti Frequent Visitor
Frequent Visitor

Re: Slice filter doesnt apply to Export to PowerPoint

This is not working for me, can you please share a video?

 

Thank you

Highlighted
bfulkers Frequent Visitor
Frequent Visitor

Re: Slice filter doesnt apply to Export to PowerPoint

Saving the report after changing filters is not an option in Apps.  This is a major issue with export to Powerpoint in my opinion.  We have a sales presentation that we want our entire sales organization to use for customer reviews.  We need to deploy the report to them through an App so that we can control the content, but we need them to be able to select filters and export to Powerpoint.

bfulkers Frequent Visitor
Frequent Visitor

Re: Slice filter doesnt apply to Export to PowerPoint

Saving the report after changing filters is not an option in Apps.  This is a major issue with export to Powerpoint in my opinion.  We have a sales presentation that we want our entire sales organization to use for customer reviews.  We need to deploy the report to them through an App so that we can control the content, but we need them to be able to select filters and export to Powerpoint.

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!

Top Ideas
Users Online
Currently online: 272 members 2,758 guests
Please welcome our newest community members: