I have a global slicer on my main page that is synced with all subpages in Power BI. I want to keep the global filter when navigating to a subpage, but I also want a local slicer on the subpage that does not send filters back to the global slicer.Is there a way to create a local slicer that:shows only the values allowed by the global slicer,affects only the subpage,and does not override or sync back to the global slicer?Looking for the best practice to achieve this without two-way slicer sync.I want to skip bookmarks to achieve it.Best,Jacek

jaryszek 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

Hi jaryszek Would it be possible for you to create a sample file that demonstrates the issue you're facing?

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.

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.

Hi jaryszek , Sure, you can refer this sample example file. To achieve this behavior, use two month tables and a switching measure that chooses which slicer to respect (Global or Local). 1. Create helper tablesA) Create a Mode SelectorSlicerSelector =DATATABLE("Option", STRING,{{"Global"},{"Local"}}) B) Create two Month tablesGlobalMonth =DISTINCT( 'Date'[MonthName] ) LocalMonth =DISTINCT( 'Date'[MonthName] ) 2. Create relationships Active relationshipDate[MonthName] → GlobalMonth[MonthName] (Active) Inactive relationshipDate[MonthName] → LocalMonth[MonthName] (Make this one Inactive) The inactive relationship will be activated only when needed using USERELATIONSHIP. 3. Create measuresBase measureTotal Sales = SUM( Sales[SalesAmount] ) Switching measure (the key logic)Total Sales (Switch) =VAR Mode = SELECTEDVALUE( SlicerSelector[Option], "Global" )RETURNSWITCH(Mode,"Global",[Total Sales],"Local",CALCULATE([Total Sales],USERELATIONSHIP('Date'[MonthName],LocalMonth[MonthName]))) This measure decides which slicer (Global or Local) should control the visuals. 4. Build the report pagesMain Page Add slicer > GlobalMonth[MonthName](This is your Global slicer.)Add slicer > SlicerSelector[Option] (optional, can be hidden)Add visuals → use Total Sales (Switch) measure SubpageAdd slicer → LocalMonth[MonthName](Do NOT sync this slicer.)Add visuals → use Total Sales (Switch) measure 5. Use buttons that set Global/Local mode automatically Since DAX cannot detect which page the user is on:Create two bookmarks:Bookmark A (Main Page): SlicerSelector = “Global”Bookmark B (Subpage): SlicerSelector = “Local” Add two buttons: On Main Page > “Go to Subpage” → triggers Bookmark BOn Subpage > “Back to Main” → triggers Bookmark A This makes the report automatically switch between Global and Local mode during navigation. Hope this helps.Thank you.

How to Keep Global Slicer While Using a Local Override on Subpages?

16 Replies

kushanNa
Super User
9 months ago
Hi jaryszek

Would it be possible for you to create a sample file that demonstrates the issue you're facing?
- jaryszek
  Super User
  9 months ago
  Hello,
  
  you cna use this sample file:
  
  https://radacad.com/download/15792/?tmstv=1763717279
  
  you have sync slicers applied there.
  
  Best,
  Jacek
  - kushanNa
    Super User
    9 months ago
    Hi jaryszek
    
    I do not see a local slicer on the subpages. Maybe you shared the wrong sample file here?
amitchandak
Super User
9 months ago
jaryszek , Sync Slicer is bidirectional, I doubt you can stop that
- jaryszek
  Super User
  9 months ago
  thanks. But for sure there is some workaround 😉
v-echaithra
Community Support
8 months ago
Hi jaryszek ,

I just wanted to check if the issue has been resolved on your end, or if you require any further assistance. Please feel free to let us know, we’re happy to help!

Thank you
Chaithra E.
- jaryszek
  Super User
  8 months ago
  Thanks, let's keep this topic open.
  
  I analuyzed your answer and gretefull for that but maybe there will be still some answers and workarounds.
  - v-echaithra
    Community Support
    8 months ago
    Hi jaryszek ,
    
    Thank you for the update. I’ll keep the thread open for now in case more workarounds or ideas come in, but the shared approaches already give me a good direction to explore. Appreciate the help!
    
    Best Regards.

Forum Discussion

How to Keep Global Slicer While Using a Local Override on Subpages?

16 Replies

Related content

Override filters

RLS Override

Override RLS

Menu with subpages on the left side

Number override