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

fb9b2372 7cbd-4426-b8c0-0cccb2913a88 on 05 Jul 2020 22:44:55

RE: Save user filters on reports

We have users who are assigned to present on different selections and they too have to select the filters for those each time if it's their region. They should be able to set their regional reports up and have them ready to present to the GMs/owners at any time.

James Snowball's profile image Profile Picture

ae7e273e 57c1-433f-ab29-9b38bb4e33a6 on 05 Jul 2020 22:43:28

RE: Save user filters on reports

I publish dashboards to managers through out the organization with information on headcount and attrition. It would be great if they could filter that reports to their needs, save it and then open that whenever they wanted. Even if they saved it under a different name, so they could view the org one, and then choose their filtered view, that would be ideal.

James Snowball's profile image Profile Picture

276e69a9 8e0d-4460-a6ad-3a62d71a649e on 05 Jul 2020 22:42:57

RE: Save user filters on reports

Multi-visual filters that work across the report would be a very nice to have. As the relationships are present in the right set of data, this should be possible. It's the only benefit I can think of Qlik Sense versus Power BI.

James Snowball's profile image Profile Picture

28f7842d d1fd-42ec-a5b2-cd6d09557710 on 05 Jul 2020 22:41:47

RE: Save user filters on reports

I think it's worth mentioning that while it's nice that Power BI remembers my last selections, this request is about saving several selections. For example, I want to bookmark several selections as "USA sales last month" and other selections as "Canada sales last year".
This is a very basic feature in most other BI products.

James Snowball's profile image Profile Picture

916fceb3 427a-47bf-8c58-2fb89129563b on 05 Jul 2020 22:41:31

RE: Save user filters on reports

The filter selection criteria needs to be saved per user so that they can go back to a report or dashboard and see refreshed data filtered the way they left it. Trying to compare between dashboards or reports and having the filters criteria dropped when switching between them makes the process take a lot longer than it needs to.

James Snowball's profile image Profile Picture

3b994b3a 3db6-4f3a-addc-55830877d465 on 05 Jul 2020 22:40:17

RE: Save user filters on reports

We really need this - our users need to be able to go straight to the area of the business in which they are responsible for without having to re-apply the filters each time. A very basic requirement!

James Snowball's profile image Profile Picture

8ea408ca 499c-4e87-b9fa-190e4d01e5e3 on 05 Jul 2020 22:37:37

RE: Save user filters on reports

It's definitely an issue for us. We've implemented a dashboard in a retail environment that a large number of people use to look at their specific areas. A user within a certain area wants to be able to ensure that the dashboard filters for their preferred filters when they visit.

We don't want to have to implement row-level security to achieve this as there are genuine use-cases where they will need to look at other areas in conjunction with their preferred area.

What they don't want to have to do is set the filters every time they access the dashboard on each of the 8 pages just so that they can see the data they want.

James Snowball's profile image Profile Picture

bb453649 92fa-450a-a16d-63e4a234ea5f on 05 Jul 2020 22:37:27

RE: Save user filters on reports

I would like to bookmark sets of filter combinations that I can reuse, say during a presentation in a staff meeting. This would help tell a story by re-applying each bookmark in a sequence to illustrate a particular point.

James Snowball's profile image Profile Picture

f995eeb0 941b-436b-b705-6483f782b486 on 05 Jul 2020 22:36:20

RE: Save user filters on reports

You need to be able to save the last filter set on a visual and page for the user so that next time they go in it is still set to the last filter applied. This functionality needs to be in the embedded solution as well...in fact is more of an issue for our organization's SaaS solution which is also hosted in the Azure environment. We get daily complaints on this functionality not existing.

James Snowball's profile image Profile Picture

28f7842d d1fd-42ec-a5b2-cd6d09557710 on 05 Jul 2020 22:35:09

RE: Save user filters on reports

I'm getting it from my users all the time. They need the ability to save their filters. It's a basic feature in all other BI products.