What Are Different Drill Modes in Power BI?

Power BI transforms static numbers into interactive stories, and one of its most powerful features is the ability to drill into your data. Instead of just looking at a high-level summary, you can dig deeper to uncover the specifics driving your results. This guide will walk you through the different drill modes in Power BI, explaining how each one helps you turn a broad overview into a detailed analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother with Drilling? The Power of Detailed Insights

Imagine your company’s annual sales report shows total revenue. That's a great start, but it doesn't tell you much. What if you could click on a single year to see how each quarter performed? Then, click on a specific quarter to see the monthly breakdown? And finally, click on a month to see which product categories drove the most sales? This is the power of drilling down.

Drilling lets you move from the "what" (e.g., "sales were down in Q3") to the "why" (e.g., "sales were down because our top-selling product in the Northeast region went out of stock"). It allows stakeholders to explore data on their own, answering their own follow-up questions without needing to request a new report. It’s the difference between a static picture and a dynamic, exploratory tool.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Setting the Stage: Hierarchies are Your Friend

Before you can use most of Power BI's drill features, you need to understand hierarchies. A hierarchy is simply a logical structure where data is organized into levels, from the most general to the most specific. Think of it like a family tree for your data.

Common examples include:

• Time Hierarchy: Year > Quarter > Month > Day
• Geographic Hierarchy: Country > State > City > ZIP Code
• Product Hierarchy: Category > Sub-Category > Product Name

Power BI is smart enough to create hierarchies automatically, especially with date fields. When you add a date field to a visual, you'll often see it broken down into Year, Quarter, Month, and Day automatically in the Fields pane. You can also create your own custom hierarchies by simply dragging one field on top of another in the Fields pane. Without a defined hierarchy, the "Drill Down" and "Expand" features won’t be available on your visuals.

1. The Classic Drill Down: Focusing on a Single Point

The most common drill mode allows you to go one level deeper into the hierarchy for a single, selected data point. It helps you focus your analysis on one specific area of interest.

Let's say you have a bar chart showing total sales by year. You notice 2023 had unusually high sales and want to investigate.

How to Use Drill Down:

1. Create a visual with hierarchical data. For our example, we'll use a bar chart with 'Year' on the x-axis and 'Total Sales' on the y-axis. Make sure 'Month' is also under 'Year' in the x-axis field well, creating a Year > Month hierarchy.
2. In the top right corner of the visual's header, you’ll see drill icons. To activate this mode, click the single downward-pointing arrow. The icon will turn dark, indicating "Drill down" mode is on.
3. Now, click on the bar representing the year 2023.
4. The chart will immediately update. The 'Year' level will disappear, and the x-axis will now show the months (January, February, March, etc.), but the data displayed is only for 2023 sales. You've successfully drilled down.

To go back up, simply click the upward-pointing arrow in the visual's header. This is the perfect tool when a specific piece of data catches your eye and you want to isolate it for closer inspection, leaving the rest of the data behind for a moment.

2. Expand: Adding the Next Level for All Points

What if you don't want to focus on a single year, but instead want to see the monthly breakdown for all years side-by-side? That’s where "Expand" comes in. It adds the next level of the hierarchy to the existing view instead of replacing it.

Using our same sales-by-year chart, let's say you want to compare how January sales in 2023 stack up against January sales in 2024.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Use Expand:

1. Start with the same chart: 'Year' on the x-axis, with 'Month' nested underneath it to form a hierarchy.
2. In the visual's header, instead of the single arrow, click the forked downward arrow icon, which represents "Expand all down one level in the hierarchy."
3. The visual will update to show both levels of the hierarchy. The x-axis will now list '2023 January', '2023 February', all the way through '2024 December'.

Expand is incredibly useful for seeing patterns over time. You might notice, for example, that sales consistently spike every November across all years. Expand piles on the detail for your entire dataset, while Drill Down isolates the detail for just one part of it.

3. Drill Through: Jumping to a Detailed Report Page

Sometimes, diving into the next level of a hierarchy isn't enough. You need to see a completely different set of details related to your selection. This is what Drill Through is for. It lets you link visuals from a summary page to a dedicated, detailed report page that filters automatically based on what you clicked.

For example, you have a summary dashboard showing sales by region. When a user clicks on the "West" region, you want them to navigate to a completely separate page that shows sales performance for individual salespeople, a list of top customers, and a product sales table, all filtered only for the West region.

How to Set Up Drill Through:

1. Create your target page: First, build a new report page with all the detailed charts and tables you want to display (e.g., Salesforce Performance Details).
2. Define the drill-through field: On this new target page, select the page itself (click on the empty canvas) to see the page-level settings in the Visualizations pane. Find the "Drill through" section, and drag the field you want to filter by into the well. In our example, you’d drag the Region field here. Power BI will automatically add a "Back" button to this page canvas.
3. Use the Drill Through feature: Now, go back to your main summary page. Right-click on a data point in a visual that contains the Region field (e.g., right-click the "West" portion of a pie chart).
4. A context menu will appear. Hover over "Drill through," and you’ll see the option to navigate to your "Salesforce Performance Details" page. Click it.

You will instantly be taken to the detail page, and every visual on that page will be filtered to show data only for the "West" region. Drill Through is a core feature for building professional-grade, multi-page reports that feel like fully interactive applications.

4. The Decomposition Tree: AI-Powered Exploratory Drilling

The methodologies above rely on predefined hierarchies. But what if you want to let users explore the data freely, choosing their own analytical path? The Decomposition Tree visual is built for exactly this purpose.

The "Decomp Tree" is an AI-powered visual that helps you find the root cause of a value by breaking it down across multiple dimensions, in any order you choose.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Use the Decomposition Tree:

1. Add the Decomposition Tree visual to your report canvas.
2. Drag the measure you want to investigate into the "Analyze" field (e.g., Total Revenue).
3. Provide the various dimensions you want to use for analysis in the "Explain by" field. You could add Region, Product Category, Sales Channel, and Campaign Name.

Once set up, the visual shows your total revenue. Next to it, there is a + sign. When a user clicks it, they can choose which of the "Explain by" fields to break the data down by first. They might choose Region. The visual then expands to show revenue per region. They can then click the + sign next to a specific region (say, "Northeast") and choose to break it down further by Product Category. This allows for a completely freeform, ad-hoc analysis right inside the dashboard.

Quick Recap: Which Mode is Right for You?

With several options available, here’s a simple cheat sheet to help you decide which one to use:

• Drill Down: Use this when you want to look at the next layer of detail for one specific part of your visual (e.g., "Show me the top products sold in February 2024").
• Expand: Use this when you want to add the next layer of detail to your entire visual at once (e.g., "Compare the product-level sales for every month side-by-side").
• Drill Through: Use this when you need to go from a high-level summary on one page to a dedicated, detailed report on another page, all while keeping the filter context.
• Decomposition Tree: Use this when you want to give your users a flexible, self-service way to conduct root cause analysis and explore data across many dimensions without being locked into a predefined path.

Final Thoughts

Mastering Power BI’s drill modes is essential for transforming static dashboards into dynamic analytical tools. By setting up hierarchies and using a combination of drill down, expand, and drill through, you empower users to move beyond surface-level metrics and truly understand the story their data is trying to tell.

For teams that need these kinds of detailed insights without the steep learning curve of tools like Power BI, we built Graphed. Instead of manually creating hierarchies, drill-through pages, and visual configurations, you can just ask questions in plain English - like "what were my top 5 products by revenue in Canada last quarter?" It connects directly to your marketing and sales data sources and instantly builds the dashboards and reports you need, allowing anyone on your team to explore data and get answers in seconds.