Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 affect page 2 but not 3 and 4.
If I select Category A on page 3 it should affect page 4 but not 1 and 2.
Slicer uses the same field on all pages and has the same name.
How to do it?
EDIT: I know Sync Slicers function. It's not solving my issue.
Solved! Go to Solution.
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.
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
Thank you for answering.
I know this option, it's not working in my case.
I need something more advanced.
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.
@AnetaK check advance sync slicers option: Slicers in Power BI - Power BI | Microsoft Learn
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
This link shows how to synchronize separare slicers while I have one slicer, same field on all pages.
When I create a new slicer on a page it automatically is treated as the same one.
I can not use them as separate.
Could anyone try to recreate my issue in pbix?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
72 | |
68 | |
41 | |
35 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |