Forum Discussion
Slicer Reverting to Previously Saved Value
- 3 years ago
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.
Anyone else have any ideas on how to fix this? Again, I want the data in the visuals on each bookmarked page to update as the user goes through the bookmarks, but the month slicer has to stay consistent - it must not change according to the bookmark. So if I'm looking at Warehouse1 data for August, and then navigate to Warehouse2, it needs to show August as well. I can't figure out how to exclude the slicer from the bookmark update.
I've included a link to a scrubbed report here for anyone that wants to play around with it:
https://occstoragemedia.blob.core.windows.net/powerbi/ShippingAnalysis_Example.pbix