Skip to main content

Announcing Persistent Filters in the Power BI Service

The feature you have all been waiting for is finally here. Today, I’m thrilled to announce the 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. That’s right – 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!

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.

clip_image002

As soon as you interact with the report (e.g. applying a filter or slicer), the button will light up and you will see the reset icon turn yellow. This is an indicator that the report is not in the default state and you have made changes.

clip_image002[4]

Note: If your button remains disabled, it either means the report author has disabled the feature for the report (see here for how) or the report contains a custom visual. Simply hover on top of the button to read the tooltip for an explanation.

Once you have modified the report to the view that you like, simply navigate away to another dashboard or report that you have access to. Soon after, go back to the report that you just modified. You should now see a tutorial dialog pop up (only on the first run for each report) that gives you a heads up that all the changes you made last time has been saved.

clip_image004

Tip: Returning to the report will always start you off on the default page set by the author.

And that’s it! Your report should be in the same state as it was when you navigated away.

If at any point you want to return to the author’s published version, just click on the “Reset to default” button and hit yes to the dialog below – your report should be back to original.

clip_image006

For your quick reference, here the list of data view changes that reports currently persist:

  • Filters
  • Slicers
  • Sort order
  • Drill location

Custom visuals are not yet supported. We are working hard to get the most popular ones compatible and have them enabled soon.

Disabling persistent filters for reports

Persistent filters is turned on by default for all reports. However, there might be some scenarios where reports are not completely optimized to leverage this feature. Which is why we added the control to disable persistent filters for reports in last month’s Desktop release. You can find this control under the Report settings option on Power BI Desktop, where checking off the box will turn off the feature for that particular report in the service.

image

As always, we appreciate your feedback on new features. If you have any comments, questions or concerns, please feel free to leave a comment below, or in the Power BI forums.