How to Use Drill Through in Power BI
- George Apostolov
How to Use Drill Through in Power BI: step-by-step guide
In Power BI Desktop, add a new report page and select a data source.
Go to the 'Visualizations pane'.
Drag the fields you want to drill through on into the 'Drill through' filters well.
The fields will appear in the drill-through area.
Power BI will show a back button on the page automatically, this lets users return to the previous page.
Add charts or bars that relate to the field. These visuals will now filter based on the selected data point from the main page.
Quick answer: To use drill through in Power BI Desktop, add a new report page, select a data source, and drag desired fields into the Drill through filters well. Next, add related charts or bars that filter based on selected data points, and use the automatically generated back button to return to the previous page.
About this Power BI tutorial
Configure drill-through filters in Power BI Desktop and add interactive visuals to filter your report pages dynamically. This guide shows how to use Drill Through in Power BI in 6 steps, starting with "In Power BI Desktop, add a new report page and select a data source" and finishing with "Add charts or bars that relate to the field. These visuals will now filter based on the...". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to use Drill Through in Power BI?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Use Filters in Power BI, How to Use Icons as Buttons in Power BI and How to Use Parameters in Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
