Home » Power BI » How to set up Drillthrough in Power BI reports

How to set up Drillthrough in Power BI reports

Drillthrough Banner

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

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

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

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

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

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

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

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 Properties

Button Propertie

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

Select Value in Visual

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

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.



Leave a Reply