Drilling through with all but one filter

[Sasha]

Hi,

I have to pages - 1 with geographical data of sales

2 - customer info

Page 1 is constantly filtered with specific dates range.

I want to drill through from 1 to 2 with all the filters from page 1 except of the dates.

I chose "off" on "keep all filters" and dragged all the relevant fields to the drill through option except of the dates.

Now it seems, like it's filtering only the field from which I do the drill through in page 1, whereas my intention to keep all filters except 1.

Anyway to pass around this?

Thanks!

[Anonymous]

Hi @Sasha ,

I haven't found any option allow you to drill through multiple filters to another page. In my opinion, I'd like to suggest you to switch your slicers to sync slicer.(filter effects can be synced between these pages based on sync slicers)

Slicers in Power BI

Regards,

Xiaoxin Sheng

[Sasha]

@Anonymous 

thanks.

The thing with syncing slicers is that these should be slicers on the tab and not in filter pane, correct?

I have many filters , most of them are not slicers in the main table.

Other option may be the user will unfilter in the drill through page, but that's very unprofessional

[Anonymous · Accepted solution]

HI @Sasha ,

Sync slicer is a additional mode of slicer, it allow one slicer existed on multiple pages and their selection can be synced on these pages.(configure on sync slicer panel)

If you turn on this option on view tab, it will display specific 'sync slicer' panel to help you to manage these slicers.

Regards,

Xiaoxin Sheng