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.

Data Format for Drillthrough-1
Step-2: Now Create a new report page for Drillthrough data, in that page drag one Clustered column chart and display the below fields.

Power Bi Visual
Step-3: Now drag the field for which you want to enable drill through into the Drill-through filters well.

DrillThrough – 2
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.

Back Button
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

Drillthrough Navigation
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.

Drillthrough Data
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.

Button in Power Bi
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

Button Propertie
Step-3: Now select any Sub category & click to button to using Ctrl+ Click.

Select Value in Visual
Step-4: Output of selected Sub Category, and to using back button you can get back to the main page.

Output
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.