Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |