How to Use Drill Through in Power BI

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to set up drill-through filtering across report pages in Power BI.

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.

📌 Why this matters

Drill through in Power BI is a critical feature for analysts who need to surface granular, context-specific insights without cluttering summary dashboards. By letting users right-click any data point and navigate to a dedicated detail page filtered to that exact value, drill through eliminates manual filtering and speeds up root-cause analysis. This capability makes Power BI reports more interactive and self-service, empowering business users to explore data relationships on their own. Teams that master drill-through navigation can build cleaner, more scalable report structures that scale across complex datasets.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI