Quick summary
Drill through in Power BI lets users right-click a data point on one report page and navigate to a dedicated detail page filtered to that specific value. Setting it up requires adding a drill-through filter field in the Visualizations pane so that all visuals on the destination page respond to the selected context.
Steps
- In Power BI Desktop, add a new report page and select a data source.
- Open the Visualizations pane from the right-hand panel.
- Drag the fields you want to filter by into the Drill through filters well.
- Confirm the fields appear in the drill-through area of the Visualizations pane.
- Note that Power BI automatically adds a back button to the page, allowing users to return to the previous report page.
- Add charts or visuals related to the drill-through field — these visuals will filter automatically based on the data point selected on the main page.
