Forum Discussion
Bookmarks Filter Data
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.
- EstherBR8 months agoHelper III
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
- mnadeemsalam8 months agoFrequent Visitor
Hi EstherBR
https://drive.google.com/file/d/1rAPFHgDc2WzrNCW1K_FEBU9JqNip2Ztm/view?usp=drive_link
Please check the file in the given link. Solution is working fine. Selection done on Country table still holds even if we move to City bookmark. and if we click on a city then country tables get filtered and we move to country table then filter still holds and not reset.
So this fix the issue you were facing.Regards,
Nadeem
If this answers your question, please mark it as a solution so others can find it easily.