Sync between Slicer and Page Level filters

[bhagyaw]

Hello,

I have created a Power BI report with a slicer named 'Office'. I also have added 'Region', 'Sub Region', and 'Sub Local Region' as page-level filters.

When selecting a value from any of the 'Region'/'Sub Region'/'Sub Local Region', the slicer lists the offices that falls under that region. But my client needs the other way round as well. That is, when an office from the slicer is selected, why not the 'Region','Sub Region','Sub Local Region' list only the respective region of the selected office on the filters pane.

Can anybody help on this please?

Thanks

[Logan_404]

Hii,
How to do reverse of this ask?
if i have on-page filter and report-level filter pointing to the same column.
if i select anything in report-level filter, i know it will filter the on-page filter/slicer. but it's not selecting the value in on-page filter (it's not clicking on the check-mark beside the value it's just filtering the value)

[v-yalanwu-msft · Accepted solution]

Hi, @bhagyaw ;

This is by design, the main difference between a Power BI slicer and a filter is that a slicer is an on-canvas, dynamic feature.
Whereas, a filter (page level in this case) is a hidden, static feature.
So Slicers can interact , Filter Can not.

So when we use a static filter on page to filter reports. Dynamic slicers are able to change with filter changes;
Conversely, when we select a slicer, the filter cannot be changed because it is static.

If you want 'Office', 'Region', 'Sub Region', and 'Sub Local Region' to change dynamically with each other, you can set them all as slicers.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.