Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
9 months ago

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

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 ...
Need Help
kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
9 months ago

Hi jaryszek 

 

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

  • jaryszek's avatar
    jaryszek
    Icon for Super User rankSuper User
    9 months ago

    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's avatar
      kushanNa
      Icon for Super User rankSuper User
      9 months ago

      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's avatar
        jaryszek
        Icon for Super User rankSuper User
        9 months ago

        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