Drill through query

[sufiyanakhtar]

Hey Power users,

I have a quickie, I have 2 sheets on my power BI desktop. THe first sheet is the overview of the spending and the second sheet is Supplier Spending related data. Now on my first sheet I have a bar chart where I am displaying the first 10 suppliers. When i drill through from that graph to the second sheet. The filters are getting applied but the data is not reflecting based on the drill through filter context. The reason i think is because there is a slicer on the second sheet. Is there any way I can override the slicer filter when i drill through to that page using the drill through filters? Please help as Im stuck on this since yesterday!!!

[Hariharan_R · Accepted solution]

Hi

If you need additional filters to be available in drill through page then you need to make it is by default selected as select all then only you will get proper result or you can sync the slicers in first page and apply the filters directly there which again  automatically passed to second page. As per my understanding the selection can't be reset  when you drillthrough from page 1.

Thanks

Hari