Forum Discussion
Drill through fields
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.
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
2 Replies
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-throughSorry 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?
