Forum Discussion

duddys's avatar
duddys
Helper I
8 months ago
Solved

Saving filter options

Hi, I have a report on Power BI Service and I need to add functionality, that when someone selects certain options in filter, on report, or in the filters in sidebar it will stay saved even after a refresh of site or reload. So if he selects released and 348 in the sidebar filter, I need for those selections to be somehow saved for him.

 

  • duddys This is automatic in the Power BI Service. The Power BI Service automatically saves user selections and filters as a sort of automated bookmark.

  • Hi, 

     

    If i understand your question correct, you may want to keep 'Don't allow end user to save filters on this report' unchecked, under Report Setting in Service

     

  • Hi duddys , by default, when you reload a report in Power BI Service, the filters revert to the report's published state unless you use persistent filters or bookmarks. This behaviour ensures consistency, but it can be changed.

     

    If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

    Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

  • Hi duddys 

     

    As what other users have already mentioned,  enabling persistent filter in the report should  be able to achieve this. Bear in mind though that persistent filters are not selective - it will save every slicer selections and the most recent bookmark a user has triggered. The are no other  options to save the user selection for just a specific filter. 

6 Replies

  • Hi duddys 

     

    As what other users have already mentioned,  enabling persistent filter in the report should  be able to achieve this. Bear in mind though that persistent filters are not selective - it will save every slicer selections and the most recent bookmark a user has triggered. The are no other  options to save the user selection for just a specific filter. 

  • duddys This is automatic in the Power BI Service. The Power BI Service automatically saves user selections and filters as a sort of automated bookmark.

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

    Hi duddys,

    Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to danextianZanquetaMasonMA & GeraldGEmerick for sharing valuable insights.

     

    Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

     

    Thank you for being part of the Microsoft Fabric Community.

     

  • Hi, 

     

    If i understand your question correct, you may want to keep 'Don't allow end user to save filters on this report' unchecked, under Report Setting in Service

     

  • Hi duddys , by default, when you reload a report in Power BI Service, the filters revert to the report's published state unless you use persistent filters or bookmarks. This behaviour ensures consistency, but it can be changed.

     

    If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

    Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

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

    Hello duddys,

    Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

    Thank you.