Drill Through should not apply to slicers in a page

[Anonymous]

Hi.

I have a requirement - i have to use drill through from page1 to page2 with Project ID but
when i apply drill through from page 1 to page 2, Project ID silcer should show all the list of projectID's How to do this ? 

as of now i tried duplicating the project ID in page 2 - slicer and still it is filtering the drill through project ID (one ID only) in the slicer. User want to see all the list of Project ID's in slicers + Drill through feature also ?
Any help please?

Thanks

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Drill through filter is used to drill the current field value to the target report pages.

If you want to keep/sync filter effects between report pages, I'd like to suggest you use sync slicer to instead.

Slicers in Power BI - Power BI | Microsoft Learn

BTW, power bi use 'AND' logic to link different filter effects. If you want to achieve custom filter effects, you may need to write measure formula to use on the 'visual level filter' to enable filter effects.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi All,

any help on the above query please?

Thanks