Are they Drill Down and Drill Through both are Same!?

[ajaybabuinturi]

If you are exploring Power BI, you might already have come across the Drill Down and Drill Through options. At first, both look similar in this way they help you explore data in detail. But in real time, they work differently and are used for different purposes.

What is Drill Down?

Drill Down helps you to explore deeper levels of your data from high level to a more detailed / lowest level within the same visual.

It is commonly used when you have hierarchy kind of data with in your data, like Year --> Quarter --> Month --> Day, Region --> Country --> City, Category --> Sub-Category and etc.

Using Drill Down option you don’t need to move another page, you are just exploring data inside the same visual.

Example:

• Let’s assume you have a Sales Overview page that has sales by year visual.
• When you click on the drill down button selecting 2025 in the slicer, visual shows you the sales by quarter.
• In this case, if you drill down again, you will see sales by month, and maybe even by day.
• Everything happens in the same visual so you don’t need to shuffle between the pages and reports.
• It is like zooming in on your data to see more detail step by step.

How to Enable:

1. You have hierarchy level of data or you need to create it.
2. Add that hierarchy into your visual.
3. Drill down option will automatically be enabled if not, enable / turn on the drill down.
4. Then you can able to see the drill down icons on the right top corner of the visual.

↑ (Drill up)      ↓ (Drill down)               ⇊ (Next level)                            ⇓ (Lowest level)

1. Now click on a fork arrow icon to go lowest level or click parallel down arrows icon to go next level or click up arrow icon  button to move back.

Advantages:

• Easy to explore the data using hierarchy basis.
• Keeps your report clean, one visual can show multiple levels of details.
• Reports looks very simple for presentations and storytelling.
• Helps find trends or issues quickly.

What is Drill Through?

Drill Through is used to move from one report page to another. If you have drill through in your visual, then you can able to see more details about any specific item on another page. Basically, it is a page-to-page navigation feature that passes your selected value as a filter to another page.

Example:

• Let’s assume you have a Sales Overview page that has sales by region visual.
• If you right-click on the East region on the visual and select Drill Through --> Region Details, you will be taken to another page.
• Now that page will show the details of only East, like top products, sales by city, or customer details.
• You don’t need to apply any filters here because already we selected specific item, Power BI ensures that keep/ready the specific item data only in the Drill Through page.

How to Enable:

1. Go to new page and create a Drill through visual, for example Customer Details.
2. Did not select any visual on the page, then go to Format --> Page Information --> Rename the Page --> Select the page type as Drillthrough --> Add Drill through filters.
3. In the Drill Through filters pane, add a field such as Customer Name or Region.
4. Now go to your main page, right-click on any value --> Drill Through --> Go to that detail page.

Advantages:

• Helps you focus on a particular area or record.
• Keeps your summary page clean and user-friendly.
• Facilitates navigation by end users: They can easily move from a high-level summary down to detailed insights.
• Ideal for role-based, department-based and analysis pages.

Supported Visuals:

Visual Type	Drill Down	Drill Through
Column / Bar Chart	Supported	Supported
Line Chart	Supported	Supported
Pie / Donut	Supported	Supported
Treemap	Supported	Supported
Matrix / Table	Supported	Supported
Map	Supported	Supported
Scatter	Supported	Supported
Slicer	Not-supported	With vertical list
Card	Not-supported	Not-supported
KPI	Not-supported	Not-supported

 

Key Differences:

Feature	Drill Down	Drill Through
Purpose	Explore hierarchy in the same visual	Move to another page with details
Navigation	Inside one visual	Between pages
Filter Context	Hierarchical levels	Selected field
Setup Required	Needs a hierarchy	Needs a Drill Through field
User Action	Click on visual icons	Right-click and select Drill Through
Best Use Case	Trend and pattern analysis	Detailed, focused view of a specific item

 

When to Use:

Drill Down:

• You have data with natural hierarchy like Date, Product or Region.
• You want users to explore without switching pages.
• You prefer simple and visual storytelling.

Drill Through:

• You want to show extra details for one selected item like a specific customer or region.
• You want to separate your detailed visuals on another page.
• You want users to move from a summary dashboard to a detailed report.

Combining Both:

You can use both features together for a great user experience.

Example:

• On your main / summary page you want to show sales by region with Drill Down (Ex: Region --> Country --> City).
• Once the user identifies a region, then they can Drill Through to a Region Insights page that shows top products, key customers, and sales trends.

This gives you the best user experience of both interactive detail and focused context.

Both Drill Down and Drill Through enable you to dig deeper into your data but in different ways. Drill Down stay in the same visual and move deeper into your hierarchy. Drill Through navigate to another page for more detailed information.

[NagaSuresh]

Thanks for Sharing @ajaybabuinturi 

[ketanTiwariAa]

Thank You Ajay for bringing this valuable information to all of us. It really helps others to understand the concepts in right and easy way. Good going. All the best.

[AbdulBasha]

Very useful 

[Presi]

Great Post @ajaybabuinturi 👏

[Murtaza_Ghafoor]

Drill Down

1. Used to explore data within the same visual.

2. Works on hierarchical fields (e.g., Year → Quarter → Month → Day).

3. Triggered by clicking the “Drill Down” arrow or double-clicking a data point.

4. Helps analyze progressive detail inside a single chart.

5. Keeps the user on the same report page.

---

Drill Through

1. Used to explore data on a different report page.

2. Activated by right-clicking a data point → “Drill Through → [Page Name]”.

3. Passes filter context (e.g., Product = “A”) to another page.

4. Useful for detailed analysis or item-level investigation.

5. Takes the user to a new page, often designed for deep dives or summaries.

---

Summary:

• Drill Down → Navigate within the same visual.

• Drill Through → Navigate to another page for details.

[Magudeswaran_MR]

@ajaybabuinturi

Thanks for sharing the insightful blog. The drill-through feature is especially valuable when you need a detailed analytical view for a specific region, category, or other dimensions.

[Vikranth426]

daily usefull infor

[suparnababu8]

Great information!