How to sync slicers across pages when tables are not related?

[KevinSV]

Hello everyone,

I’m facing a small issue in Power BI and I hope someone can help me figure it out.

Here’s the context: I’ve built a report with two pages, and each page uses data from a different table. These two tables have no relationships between them.

Each page has its own set of slicers, but the slicers represent the same filters (for example, date filters and multiple selection fields with the same names and meaning).

What I’d like to achieve is this:
When a user applies a filter on the first page, I want the same filter selection to be automatically applied to the second page-- even though the tables are not related in the data model.

I know slicer synchronization works when the same field is used, but is there any way (through a workaround, DAX, or modeling technique) to make filters from different tables stay in sync across pages?

Thanks a lot in advance for your help!

[OwenAuger · Accepted solution]

Hi @KevinSV 

Slicer synchronization can also work when different fields are used on each slicer by following the method here:

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

This works whether the slicers are on the same or different pages.

For each slicer,

1. Select the slicer
2. Open Sync Slicers pane
3. Advanced options > enter a group name (same for each slicer)
4. Select Sync filter changes to other slicers

Does this work for you?

[KevinSV]

Hello, it works perfectly ! Thank you @OwenAuger !