Forum Discussion

AnetaK's avatar
AnetaK
Helper V
1 year ago
Solved

Slicers sync/unsync

I have a report with four pages. There is a slicer Category on all of them. I want this slicer to be synchronized on pages 1 & 2, and also on 3 & 4. If I select Category A on page 1 it should affe...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi AnetaK ,

     

    I suggest you to use [Category] column from different table in P1 and P3.

    For example:

    Here I create two category slicer table and relationship is as below.

    P1&P2:

    P2&P3:

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

suparnababu8's avatar
suparnababu8
Super User
1 year ago

Hi AnetaK 

 

We have a beatiful option called Sync Slicers in Power BI desktop by using that, you can achieve it.

 

On top ribbon bar view-->click on Syn Slicers option

 

After clicking on Syn Slicers option, you'll get below window near by to filters pane.

Then, in your report you have to select any slicer, thenIt will show below like this 

So, here you can choose which filter should work on which pages by selecting above option.

 

If you need addition info..pls go through below

 

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop

https://youtu.be/03-MZBxmKVM?si=Unfr-l7Hzq1TpXat

https://youtu.be/jKOjXPkXO8U?si=awralhA35GtLOOlK  

AnetaK's avatar
AnetaK
Helper V
1 year ago

Thank you for answering.

I know this option, it's not working in my case.

I need something more advanced.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AnetaK ,

     

    I suggest you to use [Category] column from different table in P1 and P3.

    For example:

    Here I create two category slicer table and relationship is as below.

    P1&P2:

    P2&P3:

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.