Latest Enterprise DNA Initiatives


Keep all the filters of slicers on all the pages

Hi Sam,

I am looking for help on the filters of slicers on all the pages.

image
The above was the result that I wants. I was using the filter pane.

When I navigate the pages, the filters are gone like belows, all the fiscal year are shown.
image

Kindly assist.

Thank you.
Dennis

Hi
In View in the ribbon you will find an option to Sync slicers in your report.

Paul
image

Hi Paul, thanks for your reply. What I want to mean here is keep the item in slicers same. I had try to use syn slicers but it seems not work well.
I have a slicer for fiscal year 2019 to 2021, but the origin column from 2018 to 2025. I am trying to use filter pane so the slicer show only 2019 to 2021 but when I navigate from other page, the slicer change the item to all.

Hi,
Always hard to comprehend without an example pbix.
In the filter pane, using Basic Filtering and selecting the relevant years should work.
Paul
image

Hi, ya. I tried as per you said. But unfortunately when i navigate from other page to the page with slicer, the filter pane will set all to origin which is showing all the items.

Hi, are you using the “Filters on all pages” well? It works for me, I just tested it. Otherwise can you send an example pbix?
Paul

Hi Paul, thanks for your advise. I had make it successful by using filter pane and Bookmark setting. Many thanks

ok, that is fine.