Forum Discussion
Query reduction and bookmarks
Hi lvcurious ,
Based on the information you provided, you want changes to the visual object not to be applied until the button is pressed.
You can do this in two ways:
1. Uncheck the "Data" option when updating bookmarks to prevent saving the slicer state. Check that bookmarks do not store data that could trigger a query.
2. Create a customized navigation experience using buttons and bookmarks that do not trigger a data refresh until the "Apply all slicers" button is pressed.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
thank you very much for your reply.
The first option is not helpful in this situation as I need the data to be saved. The second one is what I am trying to do, but I don't know how. I cannot change bookmark navigator to regular buttons with action "bookmark".
I suppose you understand what I am trying to achieve, but here are some visuals from sample data I created for this. I am not able to attach the pbix or xlsx file here.
1. "Apply all slicers" data works only if I select anything in slicers separately.
2. Selecting a button from bookmark navigator already refreshes the data in the filters for "promotion", "sales" and "online". What I would like, is to save the changes and refresh only when "apply all slicers" button is selected.
Could you help with this problem, please?
