13 Mar’18

BIPersistent Filters in the Power BI Service


The feature is finally release, and it is power BI has announced general availability of persistent filters in the Power BI service. All Power BI reports will now automatically retain the filters, slicers, and other data view changes that you have made.

You no longer need to spend your valuable time slicing and dicing your report and repeating the same steps each time you return to the service. With this feature, you will be able to pick up right where you left off last time and quickly get to your insights!

Also, if you want to reset all the filter to the state when the report was publishing, this feature will allow you to do that.

Enabling Persistent Filter:

To see persistent filters in action, simply head to any Power BI report that you have view or edit access to. You will notice a new button on the top bar that says, “Reset to default”.

  • By default, this is disabled. It essentially means that you are viewing the author’s published view of the report and have not made any changes.

  • Once you have modified the report to the view that you like, will activate the Result to default button, and will allow you to go back to default state when it was published.

  • Click on reset to default

And you are done.  Report will be reset to the default published state.

Disabling persistent Filter for report:

Persistent filter is turned on by default for all reports. If you want to disable the feature for the report, then you need to use the latest power BI desktop version that is released on Feb 2018.

You need to navigate to : Power BI Desktop > Options > Report Settings > Persistent Filter.

This is amazing feature that allows users to interact with report as they want. Try it out and let us know if there is any issue in comments below.

Written by

Jayant Patel

Sr. Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to hide the Delete button in a page in Microsoft Dynamics NAV

    21 March’ 2018

    Introduction: By default, Delete button is visible on every page in the Home tab but if we do not want the user to dele...

    Read more
  • Managing mailbox through Email Archiving

    20 March’ 2018

    Introduction: Email can fill your Outlook Inbox quickly – new messages, replies, and forwards. Before you know it, yo...

    Read more
  • Workaround to Report.SAVEASPDF in NAV 2018

    20 March’ 2018

    Objective: In NAV 2017 Emailing the PDF by running the report using Report.SAVEASPDF is now not allowed in NAV 2018. Th...

    Read more
  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more