Forum Discussion
Slicer Reverting to Previously Saved Value
OK - I have finally managed to figure this out. I had to duplicate the tables and using a combination of filtering and hide/unhide views, and then update each bookmark. Before I just had the one table that filtered the different warehouses. Now it's two separate tables and this seems to work.
I'm baffled trying to configure the bookmarks. I've attached a scrubbed version of my report here (I hope it works) - perhaps someone wants to take a stab at how the bookmarks, slicer and visuals should be configured. What I want is that when the user selects a month from the dropdown slicer, it gets applied across all of the bookmarks (Warehouse1, Warehouse2 and Internal), as well as the different pages - Shipping Costs and Product Costs (the last page - Storage Costs - doesn't have a month applied to it). I've tried checking/unchecking Data; checking/unchecking Current Page; Selected Visuals, different combinations of all of these, but to no avail.
Thank you in advance!
https://occstoragemedia.blob.core.windows.net/powerbi/ShippingAnalysis_Example.pbix
Hi, You used Bookmark, if want to keep filter, you need to set your bookmarks don't save filter by uncheck (x) Data (picture below)
Thanks HoangHugo , but if I do that, the visuals on the different bookmarked views won't update. If I uncheck Data from the Warehouse1 bookmark, and then navigate to Warehouse2 and then back, it displays the data from Warehouse2. The filter for ShippingService doesn't update if I uncheck Data.