drill through with slicers doesnt work

[CL7777]

Struggling with this one....

I have data from a revenue table that has customer name, part number purchased, transaction date, revenue, quantity, and customer location (country and state). When I select a part number or group with a slicer, I get something like the following table:

What I want to do is be able to drill throughon a particular customer and get a table like the above for that customer only. I basically want to know everything that this customer bought (quantity, revenue, part number, and dates) regardless of the current filters. When I drill through on a particular line in the above table (for example Evergreen Industrial services on the top line), I only get the top line back in the drill through. this is because the drill through is taking into account all fields in the table, not just customer. In other words, if I drill through on the first line, this is what the drill through shows:

Evergreen Industrial serv has bought many other parts, but they dont show up in the drill through. just that one line shows up.

I have tried to create a separate table with a search field using the Attribute Slicer from the marketplace. I set the filters on the customer data table above such that they do not affect this Attribute slicer so I can get all products purchased by the customer. But, then I found out that Drill throughs do not work with Slicers (at least not how I could figure out). I could change this Attribute Slicer to a regular table and then drill through would work, but then I lose the "search" bar to find a particular customer and there are too many in the list to make it a regular table without a search bar.

please help!

thank you

[amitchandak · Accepted solution]

In the page where you are drilling, In Keep only filters you want to filter. Drag only the column you want to filter. 

So if you want to filter customer, make sure , in Add "Drill through filters", you only have customer.

Check for second last screenshot

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601