Drillthrough allows users to navigate to different report pages within a report.
With the help of Drillthrough feature in Power BI we can break down the summary data into actual figures so that we can get the detailed view of summary data.
So, Let’s start with an example, download the sample Dataset from below link
Approach-1: Implement basic Drill-through – Navigate through right click on visual
Requirement: User want to see break up of selected Sub-category sales year wise in separate page with chart visual or any visual. Refer, Step 1 Image.
Step-1: Create a Table visual to using category, Sub-category & Sales fields, this is Main Page screen shot.
Step-2: Now Create a new report page for Drillthrough data, in that page drag one Clustered column chart and display the below fields.
Step-3: Now drag the field for which you want to enable drill through into the Drill-through filters well.
When you add a field to the Drill-through filters , Power BI automatically creates a back button visual. Users can use this button to get back to the report page from which they came.
Step-4: Now go to the main page, right click to any sub category > Select Drill through > click to Page name, here “Product Details” is second page name
Step-5: After click to Page Name, it will navigate you to second page and display the year wise break up of selected sub-category.
Approach-2: How to create a Drill through Button In Power BI?
All step will be same like Approach-1, but instead to right click on visual value we will navigate through on button click.
Step-1: Add one blank button to main page > Go to Insert Tab > Click to Buttons > Select Blank Button.
Step-2: Now select button & assign the name to button & set the basic format property. And don’t forgot to select Type: Drill through & Destination: Page Name
Step-3: Now select any Sub category & click to button to using Ctrl+ Click.
Step-4: Output of selected Sub Category, and to using back button you can get back to the main page.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.