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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kosantti
Regular Visitor

How to keep filters when changing bookmark

My problem is that I've created a report (page) which has several bookmarks with different visuals and one set of filters for the report. Is there a way to keep the filter when changing the bookmark and the visual on it?

 

Can't figure a way to do this but maybe you can help me out? 

12 REPLIES 12
Bhargava99
New Member

Hi Yes it is possible. In single plage if we have multiple bookmarks are needed and selected filters are consistent at user level in Power BI service following solution can be used.

Before updating bookmarks for respective state of the visual or page we have bookmarks options in the scrolllist following as 

Bhargava99_0-1690215204994.png

 Just uncheck the Data option and update the  bookmark then it cannot effects on selected filters by the user  . Filters cannot change the state even if we switch to other bookmarks. 

Ok a combination of answers here fixed my issue. I was updating my filters on my bookmark and then selecting the visuals and hitting the 3 dot update. Things worked great between 2 of my buttons but when I changed to my 3rd button\bookmark, it would change back. REASON - 3rd bookmark had "data" checked on the 3 dots. I removed it, all is working great now! And CTRL A I use in excel and never thought to use here! thanks for that also @Anonymous and thanks @Uzi2019  

Anonymous
Not applicable

When you select the more options (3 dots) next to the bottom you see the option Selected visuals.

The Default option is all visuals. Change that

 

Next you select all visuals that you want affected by your bookmark and select the 3 dots and select update.

 

What i do is put my filters / slicers on top of my select list and the visuals / data below that. This way i can easily select the items i want to be affected with click and shift click.

Anonymous
Not applicable

Here I would add that, if your filters are in the filters pane, before selecting the option "Selected Visuals" and updating, you also have to select all visuals on your page (CTRL + A). Then, with all visuals selected you can update your bookmark.

 

@Kosantti this should keep in place even the Top N filter.

 

Hope this is clear enough.

Anonymous
Not applicable

Have you tried just leaving "page" and unselecting also visual on the bookmark settings?

Uzi2019
Super User
Super User

 

Hi @Kosantti 

 

You can change the property of bookmark by not selecting data field shown in follwing screenshot.

Capture.PNG

 

This might solve your problem. 

Please accept as a solution & kudos if it helps you.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Hey   @Uzi2019 , I know this is 3 years ago, but THANK YOU!

Hi,

 

Your solution has solved my issue. Thank you so much!

 

Cheers,

Thilini

This solves my problem of keeping filters but unfortunately does not help me that much since each visual has specific setup (top 10, bottom 10, etc.) and these dissapear when I unselect data and change the bookmark.

Not sure if this would help, but have you tried using the "Edit Interactions" in the format tab? This can break the link between a selected filter and visual. Not sure about bookmarks though, I don't use them.

Unfortunately doesn't seem to be solution when working with bookmarks.

Anonymous
Not applicable

Hi @Kosantti,

 

You can go to the bookmark pane and with a right button click on top of the bookmark you want and unselect the data check, that would fix it.

 

Tell me if it worked, if so please mark as solution.

 

BR,

DR

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.