How can we improve Power BI?

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.

679 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Justin Wlliams shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  AdminSirui Sun (Admin, Microsoft Power BI) responded  · 

    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!
    https://aka.ms/x998cx

    56 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        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?

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • KevinP commented  ·   ·  Flag as inappropriate

        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?

      • Cherie commented  ·   ·  Flag as inappropriate

        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. :-)

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Sparta commented  ·   ·  Flag as inappropriate

        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.

      • sblakeb commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        hi @Sirui Sun, any news on this idea? Its a big thing for usability in our organisation.

      • Dan commented  ·   ·  Flag as inappropriate

        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.

      • Ari Timonen commented  ·   ·  Flag as inappropriate

        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.

      • Mike Donnellan commented  ·   ·  Flag as inappropriate

        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

        IF (
        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?

      ← Previous 1 3

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.