Forum Discussion
How to Keep Global Slicer While Using a Local Override on Subpages?
Because there is no local slicer, it is just a sync slicer. And question is how to make that second page slicer will not be changing Source Page slicer even they are synced.
Best,
Jacek
Hi jaryszek
The straightforward answer would be to edit the interaction between slicers and disable it. However, based on how you described the issue in your main post, it seems more complex and likely involves additional factors & limitations (e.g., common tables, relationships, visuals, etc.). Providing an actual sample with the issue would help us determine a workaround. If possible.
- jaryszek9 months ago
Super User
Ok,
so I put Main Page and Gross Sales Analysis - Sub Page with sync slicer inside.
And now going from Main Page to Sub PAge using sync slicer.
And Months are the same. But what i want to is:
Go to SubPAge, select Month but do not propage it to Main Page.
So sync slicer should work only from Higher hierarchy page to lower, not from sub page to main page.
https://drive.google.com/file/d/1Ms3I_DoCGTi-phDyMB8QYyR6hm-wq9wW/view?usp=sharing
Best,
Jacek- kushanNa9 months ago
Super User
oh okay i get it now , like amitchandak said I also doubt that you can stop bidirectional sync slicer & skip bookmarks to achive what you need , however my workaround suggestion is to do with a global & local picker slicer
1.first create a slicer table
SlicerSelector = DATATABLE( "Option", STRING, { {"Global"}, {"Gross Sales Analysis - Sub Page"} } )2. create two months tables for both pages
3. create an inactive relationship between these two tables
4. create measures for each calculation you need ,(i have only created three in this example)
5. create these switch measure for each measure to pick which slicer
Total Gross Sales Switch = VAR SelectedOption = SELECTEDVALUE(SlicerSelector[Option], "Use Slicer 1") RETURN SWITCH( SelectedOption, "Global", CALCULATE( [Sum Gross Sales], USERELATIONSHIP(financials[Month Name], 'Global'[Month Name]) ), "Gross Sales Analysis - Sub Page", CALCULATE( [Sum Gross Sales], USERELATIONSHIP(financials[Month Name],'Gross Sales Analysis - Sub Page'[Month Name]) ) )6. and now apply these measure to each visual
7. use slicer table option column as a single select slicer , now once you pick global or local it will pick that specific slicer
I have attached the sample i have created for your reference
- jaryszek9 months ago
Super User
Thank you very much.
Hmm could i check if I am on specific sub page and pass the value to this slicer?
Best,
Jacek