Export to PowerPoint with filters applied
PowerPoint Export to take into account filters that have been applied to the report prior to export. This is essential for users which need to filter on historic dates and then wish to export the report with those details.
Hey all – we’re looking into how best to tackle this and other filter/slicer-related functionality. We’ve put together a short survey to better understand different use cases and what improvements would make the experience better. If you have a few moments, the survey takes about 10 minutes to complete. We appreciate your feedback!
Its been almost a year since last update on the matter.
Can we please get an update on the status of this feature as it is very crucial to our use of PowerBI?
Thomas Rask Thomsen commented
What is the status on this? It is really needed ...
It is possible to filter. However, you need to edit and save the report before you export it to PowerPoint. This is a huge pain. Please enable filtering and exporting without saving at first.
This is something one of our clients asks as well.
They want to distribute sales data to each salesrepresentative.
So at the moment this is not possible?
Use case: We are using the Apps now and a user would not have the ability to save the report but they would have the ability to set filters, etc. I do think Bookmarks could replace this for the most part but Power Point is nice in the fact that you can add in other visuals outside of power bi and it is not a live connection so you do not have any surprises during the presentation. :-) ...or at least limited surprises. :-)
Agree with the others below. We are about to go live with this and users will need the ability to export their search results in a professional maner for reports they are responsible for. Also want to know where you are on being able to print large filtered tables as shown in Power BI without having to export to Excel and then reformat everything.
This is essential if you want to take the charts with the data you filter and separate into other presentations. Otherwise we will need to develop separate special reports just to produce the correct data. This needs to be high priority.
The above mentioned survey is closed. This is a critical feature that needs to be functional for our Organization to use PBI. Without the ability to export with chosen filters, the PPT export function is pointless.
This feature would exponentially increase the ability to use Power BI as a presentation tool across various settings. I tried to take the survey, but it appears to have been closed. Would love an update on this feature.
I think the easiest way to handle this is when a user goes to export the report a script checks if filters are applied and prompts the user. "This report has filters/slices applied do you want to export using the current filters or report default?" This logic should apply to many of your export-to options.
The next logical step would be to show the available slicers in a report and allow the user to change them before export. Or bare minimum include on the warning screen which slicers were used and what they're currently set to.
An astute report writer should include a dynamic field that listed what filters were applied so there was no question what filters were set when the report was exported.
hi @Sirui Sun, any news on this idea? Its a big thing for usability in our organisation.
A van der Schilden commented
Hello, is it possible to get an update regarding this idea?
is there any updates on this?
It's a must have feature for the export to use all filters applied to the report when exporting.
We need it too in our work space
Joao Henriques commented
Completely useless without filters... not even sure how its an option in this state...
Our client needs this functionality.
Ari Timonen commented
It'd be vital for end user to slice the report in Power BI app and export the sliced report to a PowerPoint. This is needed for example to produce material for board meetings and such.
Survey no longer works...
Mike Donnellan commented
Our client needs this functionality today. Also need to way to get all filters out of a page into a list without creating many many measures of the form
NOT ( ISFILTERED ( <stuff>)))
and then concatenating everything together. Obviously something in Power BI knows what filters are applied on a page. How about PageFilterTable and PageFilterTextbox? Or a function usable in a measure, maybe even with formatting options?