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

5cac44ff 3961-47ec-84a9-1ff1b4786f6b on 05 Jul 2020 23:19:55

RE: Save user filters on reports

This can be considered partially done and not Done Done.
We need basic options like saving multiple Views, Save Filters, Visual states (e.g if on a Map View, A user has clicked on a region to drill the data to that region, This should persist)

James Snowball's profile image Profile Picture

203237e3 3960-e811-a960-000d3a1be90a on 05 Jul 2020 23:17:57

RE: Save user filters on reports

I agree with other comments. We need the ability to save multiple views like Tableau had. Is this possible in some other way?

James Snowball's profile image Profile Picture

28f7842d d1fd-42ec-a5b2-cd6d09557710 on 05 Jul 2020 23:16:17

RE: Save user filters on reports

I'm very disappointed by the feature. Users should be able to save multiple combinations, like in Tableau.

James Snowball's profile image Profile Picture

7029fb3e 5776-4ff6-b1d4-30db14e9b267 on 05 Jul 2020 23:16:15

RE: Save user filters on reports

This feature is at the moment bringing more bad then good. This still does not allow users to save the current state of their filters, it onl allows them to pick up where they were. However, in most cases they dont open it to pick up where they were at , but are just confused that there are already filters in place. Please allow users to save presets of filters

E.g. : user makes preset
Sales check Region X : sets a filter on region A, deselects some countries, and removes all things with property Z.

James Snowball's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:16:15

RE: Save user filters on reports

Except for the hierarchy slicer which this doesn't work for. So I am waiting for this to work with that.

James Snowball's profile image Profile Picture

5bf54a43 419d-4954-aab6-8fc40c0450a1 on 05 Jul 2020 23:15:32

RE: Save user filters on reports

Can this feature be disabled from the service?

For one lot of reports I need to force the user to filter each time. But the report was not made in BI Desktop, it was made purely in Power BI Service. I don't want to have to recreate all the reports just for this reason.

James Snowball's profile image Profile Picture

9677d792 964d-4693-b948-1780fa016568 on 05 Jul 2020 23:15:21

RE: Save user filters on reports

Is there a way to check if this has been rolled out to my tenant?

James Snowball's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:14:47

RE: Save user filters on reports

Some PBI Service tenants have already seen this feature activated, our PBI Service tenant has not expressed this feature yet... is this a slow roll, or some other delay? When can we expect this to be fully rolled out?

James Snowball's profile image Profile Picture

182c7348 3e7f-4d6f-b9e9-b930b5443c60 on 05 Jul 2020 23:14:15

RE: Save user filters on reports

To use the February persistent filter update, users have to have write access, correct?

James Snowball's profile image Profile Picture

d08a9193 8461-4881-8d20-181a73c5ee57 on 05 Jul 2020 23:14:15

RE: Save user filters on reports

For Reportserver too?