Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@NewbytoPowerBI , 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
@NewbytoPowerBI , 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
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |