Drill through fields

[Anonymous]

Going to try posting this again but with a screenshot to explain it a little better.  Ive imported my excel file, selected the fields i want included, and now  I want to drill through the data by this field called 'provider address'.  I have dragged the field from the right hand side Fields section to the 'add drill through fields here' box.  I now want to create separe excel reports by ticking the relevant address fields.  BUT it only lets me tick one address at a time.  Is there a way to select multiple options to create the report based on what I have ticked?  OR alternatively it it possible for Power BI to automatically export a separate excel sheet based off each of those address fields, without me having to tick any fields.  

[amitchandak · Accepted solution]

@Anonymous , Try after pressing Ctrl Key

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

[FAY2020]

Sorry to resurrect this thread but is there any way to drill through from another page with multiple selections? If this works with ctrl+click on the actual drill through destination page, it should work when using a button to start the drillthrough, right?