Forum Discussion

EstherBR's avatar
EstherBR
Helper III
8 months ago
Solved

Bookmarks Filter Data

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!

 

 

 

 

 

11 Replies

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

     

  • 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's avatar
      EstherBR
      Helper III

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

      • amitchandak's avatar
        amitchandak
        Super User

        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 

         

  • mnadeemsalam's avatar
    mnadeemsalam
    Frequent Visitor

    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.

  • v-prasare's avatar
    v-prasare
    Community Support

    Hi EstherBR,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

    • EstherBR's avatar
      EstherBR
      Helper III

      Hi v-prasare, I finally solved it with a drill trough, since the bookmark was not working.

      • v-prasare's avatar
        v-prasare
        Community Support

        Thanks for the update here. Please reach out to foru community if you have more questions.

  • v-prasare's avatar
    v-prasare
    Community Support

    Hi @EstherBR,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support