cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Maintain Slicer Values through Bookmarks

Hi All,

 

I have a slicer called team and with values let's say 'A','B','C'. I have also created buttons Summary and Detail.

 

I am enabling different visuals using bookmarks for these buttons.

 

However the problem is the slicer does not maintain the value between different views of Summary and Detail.

 

e.g. I am in a Summary Section wiht Team 'A' selected and default view "Summary". When I click on Detail button the slicer changes it's value to "All".

 

Note : I do not want to set filter level to report level.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V
Super User V

Re: Maintain Slicer Values through Bookmarks

Hi @npowerbi,

 

On the bookmarks pane, right click on your bookmarks and deselect the Data option:

 

bookmarks_05.png

 

When you create a bookmark with this option active it will always return to that specific filter in your case is the All.

 

If you do this for all your bookmarks you should be abble to go from one to the other keeping slicer choice.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

12 REPLIES 12
Highlighted
Super User V
Super User V

Re: Maintain Slicer Values through Bookmarks

Hi @npowerbi,

 

On the bookmarks pane, right click on your bookmarks and deselect the Data option:

 

bookmarks_05.png

 

When you create a bookmark with this option active it will always return to that specific filter in your case is the All.

 

If you do this for all your bookmarks you should be abble to go from one to the other keeping slicer choice.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

Highlighted
Helper I
Helper I

Re: Maintain Slicer Values through Bookmarks

That worked like a charm 🙂 Thanks a ton for a quick tip. Appreciate your help.

Highlighted
Helper I
Helper I

Re: Maintain Slicer Values through Bookmarks

Hi @MFelix,

 

Its true that unchecking the Data from bookmarks will keep slicer values across bookmarks, however it removes ALL filters regardless of if its a Page Filter, Visual Filter, or Slicer, which means that any default filters are dropped. Is it possible to retain default filters on the visuals while still allowing a single specific slicer to carry across bookmarks? 

Highlighted
Super User V
Super User V

Re: Maintain Slicer Values through Bookmarks

Hi @benisanders,

 

 

What you want is the contrary to what is in this post, is to maintain the filters when you return to the bookmark. So you need to have the Data option active, that way everytime you return to the bookmark will pick up the default values for the slicers.

 

Regards.

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: Maintain Slicer Values through Bookmarks

Hi @MFelix

 

Im sorry if i was not clear. I am looking for the same functionality as the original post, to be able to pass the slicer value across bookmarks. The only difference is that I am trying to accomplish this for a single a single slicer only. All other filters / slicers should remain as bookmarked. 

 

Ie. If you have a table with columns A,B,C and a Slicer on A with two bookmarked views D and E. In a chart/table I want to be able to set a default filter for Column B which would be different for bookmark D and E, but then maintain my slicer selection for column A across both bookmarks. When I unselect Data from the bookmarks the default filter for Column B is dropped as well.

Highlighted
Super User V
Super User V

Re: Maintain Slicer Values through Bookmarks

Hi @benisanders,

 

In this case you need to use the option "Selected Visuals".

 

You need to place the default values on your slicer and then selecting all those slicers create a bookmark and select the option Selected visuals, keeping the Data option active.

 

When you do that the all the slicer will keep the values on other slicers but the one you select will go back to the default values.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: Maintain Slicer Values through Bookmarks

Thanks, thats what I was afraid of. It makes it exponentially more annoying to add new visuals into existing bookmarks when its Selected rather than All, since you need to select all of the visuals again each time you need to change.

Highlighted
Super User V
Super User V

Re: Maintain Slicer Values through Bookmarks

Hi @benisanders,

You only meed to select the slicers that you want to have default values not all the visuals because the visuals will be update accordingly to the slicers.

You only have to redo the selection if you add additional slicers that you want to have default values
Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Resolver I
Resolver I

Re: Maintain Slicer Values through Bookmarks

Hi MFelix,

 

I was going throught this post and found very useful and was able to resolve my issue.

 

But, i have an added scenario to this, so i thought this would be the right place to add.

 

I was able to maintain default filters, but when i use a flip button to shift between two bookmarks, the buttons do not interchange.

 

I.e We have two views -  Unknown, Known

 

There is a default slicer for unknown, which i selected and created a bookmark with selected visual and data as active. It is working fine if i switch between the pages with the selected filters.

 

But when i try to do the same with a flip button (I used images here).  The visibility that i gave to thse buttons is not syncing between both the bookmarks.

 

Could you please help.

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors