cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
a68tbird
Resolver II
Resolver II

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

1 ACCEPTED SOLUTION
a68tbird
Resolver II
Resolver II

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.  

View solution in original post

7 REPLIES 7
a68tbird
Resolver II
Resolver II

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.  

a68tbird
Resolver II
Resolver II

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

 

a68tbird
Resolver II
Resolver II

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)

bookmark.png

 

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. 

Greg_Deckler
Super User
Super User

@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".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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. 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

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!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors