Drillthrough (Power BI)

What is drillthrough in Power BI?

Drillthrough in Power BI is a report interaction that takes you from a summary visual to a separate page filtered to whatever you selected. You right-click a bar for one product, or select a drillthrough button, and Power BI opens a detail page that shows only that product: its sales history, its margins, its open orders.

The summary page answers "which products sell best". The drillthrough page answers "so what is going on with this one". Instead of cramming both levels onto a single crowded page, you keep the overview clean and send people to the detail on demand.

Power BI carries the context across automatically. If you drill through from the March bar for the Antwerp store, the detail page arrives already filtered to March and Antwerp, without the reader touching a single slicer.

How drillthrough works

A report author builds a dedicated detail page and drops one or more fields into its drillthrough filter well, for example Product Name or Customer. Those fields decide what the page filters on when someone arrives. As soon as a drillthrough field is added, Power BI puts a back button on the page so readers can return to where they came from.

Readers reach the page in one of two ways. They can right-click a data point that contains the drillthrough field and pick the destination from the menu, or the author can place a drillthrough button that only activates once the right selection is made. A button is more visible than a hidden right-click menu, which helps for reports shared with people who did not build them.

Drillthrough versus drill down

The two names sound alike and get mixed up constantly, but they do different things.

Drill down stays inside one visual and moves through a hierarchy: year to quarter to month, country to region to city. The page does not change; the same chart just shows a finer level.

Drillthrough leaves the visual and opens a different page filtered to your selection. Use drill down to explore levels of the same chart, and drillthrough to jump to a fuller picture of one item.

Cross-report drillthrough

Drillthrough usually stays inside one report, but you can also drill from one report to another. Cross-report drillthrough lets a summary in one report send the reader to a detail page in a different report, as long as both live in the same workspace and share matching field names and data types. It has to be switched on in the target report's settings, and it works in the Power BI service rather than in Desktop.

This suits a common setup in self-service analytics: one high-level executive report links out to specialised reports owned by separate teams, so the summary and the deep dives can be maintained independently.

Drillthrough in paginated reports

The idea also exists in paginated reports built with Power BI Report Builder, where a drillthrough report is a separate report opened when a user selects a link. Paginated reports allow chains of drillthrough down several levels of child reports, which fits print-style and operational documents where each click opens the next layer of detail. The concept is the same as in interactive reports: start general, click through to specific.