Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |