Forum Discussion
Saving Multiple Filter Preferences per user
We're trying to build a functionality where a user can save his/her filter (slicer) preferences.
The user should be able to select multiple values from the different slicers on the report and save the preference with a particular name.
The user should also be able to apply any of his/her saved filter preference to the report (by selecting from the list).
4 Replies
Power BI has something called persistent filters wherein if a report is saved using this option enables a user's previously selected filter options for the report he/she accessed gets saved. There is no function which can save these selections and apply globally to all future or select reports or dashboards.
Couple of workarounds:
- You can use RLS if this is for a limited amount of people.
- Or save snapshot's of a report using bookmarking per user which is very cumbersome and inefficient.
Thank you for you reply.
Yes, I am aware of the persistent filter functionality. But this functionality is only for ONE combination (the last one the user selected). What we need is for the user to select & save multiple combinations. Example:
Slicers on the report: Country, Car
User selects: Country = United States, Car = Tesla [saves this selection as "My Selection - Tesla_US"]
User selects: Country = Canada, Car = BMW [saves this selection as "My Selection - BW_CAN"]
Later when user opens the reports, he/she can select between the pre-selected filter preferences:
- My Selection - Tesla_US
- My Selection - BW_CAN
