Skip to main content

Power BI

Completed

Save user filters on reports

Vote (614) Share
James Snowball's profile image

James Snowball on 28 May 2015 14:48:34

The most common request from my users is for Power BI to save the filters and settings that a user applies on a report. Currently they need to re-apply everytime they open it.

Administrator on 26 Mar 2018 14:18:07

Hey everyone, the wait is finally over. For those who follow our blog closely, we shipped this feature in the service earlier this month: https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/ Thanks again for all the support!

Comments (87)
James Snowball's profile image Profile Picture

Mark Eng on 05 Jul 2020 23:07:39

RE: Save user filters on reports

Any updates on when this would be available? Similar to some comments below - our users are also asking for this functionality to save filters

James Snowball's profile image Profile Picture

Alan Sloan on 05 Jul 2020 23:06:15

RE: Save user filters on reports

Something I would like to suggest with this feature would be to maintain the ability to "one-click reset" filters. This way, if a user accidentally makes a change, they won't have to track down the specific change and reset it, they may simply return to the default filter settings.

James Snowball's profile image Profile Picture

berpa on 05 Jul 2020 23:05:47

RE: Save user filters on reports

same idea : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15198462-persisting-default-selections-for-different-users

James Snowball's profile image Profile Picture

kapil Dev on 05 Jul 2020 23:05:01

RE: Save user filters on reports

Can you please let us know when this feature will be available, my client is keeps on asking.

James Snowball's profile image Profile Picture

Dario on 05 Jul 2020 23:04:57

RE: Save user filters on reports

It's a fantastic one! Or even personalized Bookmarks can be the key (and an big big big enhancements to how different audiences within one organization use Power BI)

James Snowball's profile image Profile Picture

Power BI User on 05 Jul 2020 23:04:44

RE: Save user filters on reports

This feature will really help to simplify our code and speed up delivery. Any update on when this functionality can be added?

James Snowball's profile image Profile Picture

Power BI User on 05 Jul 2020 23:02:50

RE: Save user filters on reports

Could this 'idea' be combined/merged with the 'Personalised bookmarks' issue, as they are essentially the same requirement (albeit phrased slightly differently)?
This one: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31788253-personalized-bookmarks

James Snowball's profile image Profile Picture

Jennifer Beckett on 05 Jul 2020 23:00:22

RE: Save user filters on reports

Users need to be able to create and save filters that can be applied to any report or dashboard. There needs to be a 'library' of filters. These filters should be able to be created by uploading a text or excel file too. For instance, users want to be able group all hurricane stores together and these stores may change as they track the hurricane. They don't want to have to go into PBI and manually select and deselect stores. They want to share this filter with other users to apply to other reports. PBI needs a system to manage and share filters in order to be useful for retail analytics.

James Snowball's profile image Profile Picture

Mikkel Dam on 05 Jul 2020 23:00:22

RE: Save user filters on reports

Lets say you created a report showing revenue per month split up by products, each employee has about 15 product s which they are responsible for, every employee have the possibility to use a slicer on products to filter down on only the products they are responsible for selling. Each time the employees enters the report they have to filter out irrelevant products to generate their desired view.

As it is right now they will have to use the slicer every time they use the report, which is very annoying if they have to select 50 products, 20 cities etc.

James Snowball's profile image Profile Picture

Bennie Lopez on 05 Jul 2020 22:59:42

RE: Save user filters on reports

I knew there would be idea already for this...I was asked about this today by one of our users...Please bump up from "Under Review", thanks,