How to Use Drill Through in Power BI

‍

‍

Using Drillthrough in Power BI is super useful for navigating from a summary view to a detailed view of your data. Here’s how to do it:

‍

1. In Power BI Desktop, add a new report page and select a data source.
2. Go to the 'Visualizations pane'.
3. Drag the fields you want to drill through on into the 'Drill through' filters well.
4. The fields will appear in the drill-through area.
5. Power BI will show a back button on the page automatically, this lets users return to the previous page.
6. Add charts or bars that relate to the field. These visuals will now filter based on the selected data point from the main page.