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

[jaryszek]

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

[v-echaithra]

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]

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. 

[kushanNa]

Hi @jaryszek 

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

[jaryszek]

Hello,

you cna use this sample file:

https://radacad.com/download/15792/?tmstv=1763717279

you have sync slicers applied there.

Best,
Jacek

[kushanNa]

Hi @jaryszek 

I do not see a local slicer on the subpages. Maybe you shared the wrong sample file here?

[jaryszek]

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

[kushanNa]

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.

[jaryszek]

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

[kushanNa]

@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 

[jaryszek]

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-echaithra]

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.

[jaryszek]

Thank you,

can you please share any example how this can work? 

Best,
Jacek

[v-echaithra]

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 tables
A) Create a Mode Selector
SlicerSelector =
DATATABLE(
"Option", STRING,
{
{"Global"},
{"Local"}
})

B) Create two Month tables
GlobalMonth =
DISTINCT( 'Date'[MonthName] )

LocalMonth =
DISTINCT( 'Date'[MonthName] )

2. Create relationships

Active relationship
Date[MonthName] → GlobalMonth[MonthName] (Active)

Inactive relationship
Date[MonthName] → LocalMonth[MonthName] (Make this one Inactive)

The inactive relationship will be activated only when needed using USERELATIONSHIP.

3. Create measures
Base measure
Total Sales = SUM( Sales[SalesAmount] )

Switching measure (the key logic)
Total Sales (Switch) =
VAR Mode = SELECTEDVALUE( SlicerSelector[Option], "Global" )
RETURN
SWITCH(
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 pages

Main 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

Subpage
Add 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 B
On 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.

[amitchandak]

@jaryszek , Sync Slicer is bidirectional, I doubt you can stop that 

[jaryszek]

thanks. But for sure there is some workaround 😉