Bookmarks Filter Data

[EstherBR]

Hi,

I have created the following bookmarks:

I would like that when I select a country code in the Country code table, it filters the City Table.

So the result when I click on the city bookmark the result should be:

But currently the country code filter is removed when I click on the city bookmark navigator, so the result is the following.

How can I make that the country code table filters the city table even when I click on the bookamrk navigator?

Thanks!

[mnadeemsalam]

Hi @EstherBR 

You can definitely achieve this, but the key point is that bookmarks do not store filter context. They only store the layout and visibility state of visuals. That means when you switch from the Country bookmark to the City bookmark, the country you clicked is not automatically passed through unless you set things up correctly.

Here are the steps to make it work:

1. Make sure your City table is filtered by the Country table

Check that your data model has a relationship like:
Country → City
(one-to-many, single direction).
This ensures that selecting a country will filter the list of cities.

2. Do NOT include data filters in your bookmarks

When creating bookmarks, uncheck the “Data” option in the bookmark settings.
If Data is checked, Power BI freezes the filter state and ignores new selections made by the user.

You want:

• Data = Off

• Display = On

• Current page = On

3. The bookmarks should only switch the view, not the filters

Your Country bookmark should show the table visual with countries.
Your City bookmark should show the separate table visual with cities.
Because Data is turned off, your country selection will stay active when switching bookmarks.

4. Test the flow

• Click a country in the country visual

• Then click the City bookmark

• The city table visual should now only show the cities for the selected country

If this still doesn’t work, it usually means that the relationship between Country and City isn’t set up correctly, or the bookmark was originally saved with Data turned on.

If you can share a small sample PBIX with similar data, I can point out exactly where the issue is.

Regards,

Nadeem

If this answers your question, please mark it as a solution so others can find it easily.

[EstherBR]

Hi @mnadeemsalam, all fields are in the same table. You can download the PBIX in the following link: https://drive.google.com/file/d/1rbBPJlT9XSC2IadgvsDAb5bXZqyTEZSg/view?usp=sharing

[rohit1991]

Hii @EstherBR 

Bookmarks do not keep slicer or table selections unless you explicitly capture them. When you click the City bookmark, it restores the page exactly as it was when that bookmark was saved  which is why the Country Code filter disappears.

To keep the Country Code selection applied when switching bookmarks, use this setup:

1. Do NOT include the slicers/tables in the bookmark.
   When saving the bookmark, choose Selected visuals and exclude both slicers/tables.

2. Let the filter context flow naturally from the model.
   This way, the City table will always react to the current Country Code selection, even after changing bookmarks.

Once you remove the slicers from the bookmark scope and re-save, the Country Code selection will continue filtering the City table correctly.

[EstherBR]

Hi @rohit1991, Could you provide an screenshot of how the bookmark should look. I cannot attach my file.

[amitchandak]

@EstherBR , I doubt cross-highlight can pass , You can enable drill down in Matrix visual , and then it drill to that value 

Click on Brand name, not the button(+ button can be removed)

drill up to go back 

[amitchandak]

@EstherBR , if you need to pass Slicer value across bookmarks, then uncheck the Data option on both bookmarks. Option on right click