Forum Discussion
Slicer Reverting to Previously Saved Value
Hello All -
Can't figure out why the Month slicer on my report keeps reverting back to a previously saved value, even after I save the report with a new value. The slicer is used on three pages of the report. Even if I select a new value, go to a different page, and then back to the first page, the slicer has gone back to the original value. Am I missing a setting somewhere? Seems like this would be an easy fix, but not sure what I'm looking for to fix it.
Thanks
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.
7 Replies
a68tbird Hmm, never seen that before. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".OK, I believe I know what is causing this problem. My description above was not quite accurate. I have report with three pages, the first page has three bookmarked views. As I go from bookmark to bookmark, I want the month selected in the slicer to remain the same. In fact, the slicer value should not change from page to page, or bookmark to bookmark. So it's how I'm updating the bookmark on each view. I know that there are Bookmark configurations - like Data and Selected Visuals - just trying to understand how these are applied.
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.
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
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.
