Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to Solution.
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.
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
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.
@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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!