How to Add a Drill Through in Power BI

Updated on:

April 6, 2026

By:

Madhav Bhandari

Use this interactive demo to learn how to add a drill through in your Power BI reports.

‍

It is very easy to add a Drill Through in Power BI. Here’s a short guide on how to do it in simple steps:

‍

Under the Data pane, click the table that contains the field you want to use.
Following that, select your preferred field and then drag it to the Drill Through section in the visualizations pane.
Tap the Filter menu and select one from the given choices.
Subsequently, tick the checkbox next to the dataset you want to use.
After completing these steps, a Drill Through will be added to your Power BI report based on your input.

📌 Why this matters

Adding drill through transforms static dashboards into interactive exploration tools. You can click any data point and instantly navigate to detailed views with relevant context automatically filtered. This eliminates the need to manually adjust filters or hunt through multiple report pages.

The real power emerges when stakeholders can self-serve their analysis without constantly requesting custom reports from you. They discover insights through natural curiosity-driven clicks, while you avoid becoming a bottleneck for every data question that arises during meetings.

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