Bookmarks question - Page Level filter and Slicer

[Anonymous]

Hello

I am not sure if this question is already answered.

Here is my question -

When saving bookmark, I want that page level filters should be saved. However, if I select "Data" option while updating bookmark, it also saves the slicer selection.

I dont want slicers to be saved.

Any idea on how to do this?

One option for me is to create 2 different pages to achieve this (and use one page each for my page level filter combination), but I want to know if this can be accomplished with a single page.

Regards

[Anonymous]

@Anonymous,

You can create same visuals and a slicer without selection, then create bookmark with toggle as shown in the following PBIX file.

https://1drv.ms/u/s!AhsotbnGu1Nokz-iFj6hTkQDHxGz

Reference:
https://www.youtube.com/watch?v=_Afcj8mT5_Q

Regards,
Lydia

[Anonymous]

@Anonymous

The PBIX file link is blocked at my work place.

Do you have any other way to send me the same?

Regards

[Anonymous]

@Anonymous,

Check if the attached PBIX file is available.


Regards,
Lydia

[Anonymous]

@Anonymous

Thanks, I was able to download this time.

So if I understand it correctly, you are suggesting to use slicer with selected value and not use page level filter, right?

If that is true, I think this solution is not flexible enough to cater to future values of a field (slicer).

However, for page level filter, we can write things such as "contain", "does not contain", etc.

So, I am not sure if your solution will work correctly.

Regards

[Anonymous]

@Anonymous,

When you convert the toggle button from Left to Right, you can note that page level filter is used in both scenarios. The difference is that no selection in the slicer when you turn toggle button to Left.

Regards,
Lydia

[Anonymous]

@Anonymous 

Yes, I understood that.

My question is - is this solution scaleable enough in the sense that once the values in your slicer change?

For eg, I have a column called Category with values "Elec1", "Elec2", "Elec3", "Clothing1", "Clothing2", "Clothing3".

I am saving one bookmark with slicer values "Elec1", "Elec2", "Elec3".

Another bookmark with values "Clothing1", "Clothing2", "Clothing3".

Now, if there is a value called "Elec4" in future, how will that be included as part of 1st bookmark?

Hope you get my point.

Regards

[Anonymous · Accepted solution]

@Anonymous,

You would need to manually select the new value in your slicer and update the 1st bookmark.

Regards,
Lydia

[danextian]

I also had the same question. I want to be able to separate the filter for slicer and page filter.  I guess this feature will be added in the future. For now, selecting Data option either adds the slicer and page/drillthrough filter to the bookmark and not just either. Until this feature is already available. I avoid using bookmarks in a page where there are both page and slicer filters.