Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
atanubose
Regular Visitor

Saving Multiple Filter Preferences per user

Hi,
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).
 
How can we achieve this easily in Power BI?
 
We were trying to implement this using a PowerApp. We are able to capture and save the slicer values selected by the user but we're finding it difficult to reapply them to the report. Help please?
4 REPLIES 4
nirvana_moksh
Impactful Individual
Impactful Individual

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:

  1. You can use RLS if this is for a limited amount of people.
  2. 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

Hi Bose ,

Were you able to achieve this request ,if so plz suggest how 

Anonymous
Not applicable

Hey atanubose,
This feature has been added in recent versions, called "Bookmarks"

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors