Forum Discussion
How to Keep Global Slicer While Using a Local Override on Subpages?
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.
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- v-echaithra9 months ago
Community Support
Hi jaryszek ,
Thank you kushanNa for your valuable inputs.There is no DAX function that returns the current page, you can’t build a purely DAX-based page detector. But you can try this approach using Bookmarks + navigation buttons. create a “Go to Subpage” button that triggers a bookmark which both navigates and sets the slicer state you want. This effectively passes a value to slicers without user fiddling. It’s the typical workaround we can suggest.
Best regards.