Forum Discussion

Sonicks's avatar
Sonicks
Regular Visitor
1 year ago

Rebuild 'Legacy report' Bookmarks for Cross-Report Filtering

Hi all,

I’m working on transitioning legacy bookmarks in my Power BI report to support cross-report filtering by moving their filtering logic into the data model.

 

Currently, I have:
31 bookmarks, each containing 3 to 7 filters
Filters applied across different columns from multiple tables
In total, this results in 227 unique filter variations

 

I’m looking for the best approach to restructure this filtering logic without relying on bookmarks. Has anyone tackled a similar challenge? Any insights on how to approach this efficiently would be greatly appreciated!

 

Thanks in advance! 🚀

4 Replies

  • Hi Sonicks ,

     

    This depends on what the bookmarks do exactly, but I would look into applying Field Parameters, Slicers and Calculation Groups.

     

    It seems to me that someone built all this bookmarks just to have the default values of specific filters, this is not a good option since bookmarks are very difficult to maintain.

     

    I would probably start by trying to build a different UI/UX experience.

    • Sonicks's avatar
      Sonicks
      Regular Visitor

      Thank you for your response—I understand your point.

       

      However, I currently lack the technical knowledge and experience to implement this correctly.

       

      Therefore, I’m looking for concrete examples where filters from the filter pane are stored as bookmarks and then converted into a data model that handles the filtering instead.

       

      Do you have any experience with this?

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User

        There is no direct way to see this, in terms of the bookmarks this is a big miss on th ebookmarks but you don't have a direct option to check what are the filters applied to a bookmark.

         

        You can try and use Power BI field finder to check what are the filters used on specific pages:

         

        https://github.com/stephbruno/Power-BI-Field-Finder

         

        You can also store the PBIX file has Power BI project and on the folder for bookmarks check what are the filter applied.