How to Enable Drill Down in Power BI

Your Power BI dashboard shows the big-picture summary, but true insights often hide in the details. You need a way to go from "total sales" to "which product sold the most in the Pacific Northwest last Tuesday?" without building a dozen different reports. This is precisely what the drill-down functionality is for. This article will walk you through exactly how to set up and use drill-down features in Power BI to turn your static charts into interactive, exploratory tools.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is Drill Down in Power BI?

Drill down is an interactive feature that allows you and your report viewers to explore different levels of your data within a single visual. Think of it like a set of Russian nesting dolls. You start with the largest doll (a high-level summary, like yearly sales), and then you can open it up to reveal the next level (quarterly sales), then the next (monthly sales), and so on.

Instead of creating separate charts for sales by year, sales by quarter, and sales by month, you can create one intuitive chart that lets users navigate through these layers on their own. This encourages data exploration, helps users answer their own follow-up questions, and saves you a ton of time building reports.

When should you use drill down?

You’ll find drill-down useful anytime your data has a natural, logical hierarchy. Here are a few common examples:

• Time-Based Data: Year → Quarter → Month → Day
• Product Catalogs: Product Category → Sub-Category → Product Name → SKU
• Geographic Data: Country → State/Province → City → ZIP Code
• Organizational Structure: Company → Division → Department → Team

Setting Up Your First Drill-Down Visual

Enabling drill-down in Power BI is all about setting up a proper hierarchy in your visuals. The process is straightforward and only takes a few steps.

For this example, let's say we have sales data and we want to create a column chart where we can see Total Sales by Product Category, then drill down to see sales by Product Sub-Category, and finally by individual Product Name.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Choose a Visual and Add Your Top-Level Field

First, select a visual that supports drill down. Bar charts, column charts, line charts, and pie charts are all great choices. Let’s create a simple clustered column chart for our sales data.

1. Click on the Clustered column chart icon in the Visualizations pane.
2. From your Fields pane, drag your main measure (e.g., Sales Amount) into the "Y-axis" field well.
3. Next, drag your top-level hierarchy field (e.g., Product Category) into the "X-axis" field well.

At this point, you'll have a standard chart showing sales by product category. Nothing interactive yet.

Step 2: Build the Hierarchy in Your Visual

This is where the magic happens. To create the drill-down path, you simply add more fields below your top-level field in the same field well. The order is crucial, as it defines the drill path.

1. Drag your second-level field (Product Sub-Category) from the Fields pane and drop it directly below Product Category in the X-axis well.
2. Drag your third-level field (Product Name) and drop it below Product Sub-Category in the same well.

In the Visualizations pane, your X-axis box should now contain your fields in the correct hierarchical order:

• Product Category
• Product Sub-Category
• Product Name

Step 3: Enable the Drill-Down Icons

Once you’ve added more than one field to an axis, Power BI automatically adds several small arrow icons to the header of your visual. By default, they may be greyed out. These controls are your users' gateway to exploring the data.

That's all for the setup! You've successfully enabled drill down on your visual. Now let's see how to use it.

Navigating Through Your Data Levels

With your hierarchy in place, you can now interact with the data layers using the icons in the visual's header or by right-clicking on data points.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Using the Header Icons

There are typically three key icons for drilling up and down. Understanding what each does is key to fluent analysis.

1. Turn on Drill Down (The single downward arrow)

This is the most common way to drill down. You use it to explore a single specific category.

• How to use it: Click the single downward arrow icon to activate it (it will turn dark). Then, click on a specific column in your chart. For instance, if you click on the "Bikes" column, the chart will re-render to show you a breakdown of sales by Product Sub-Category for "Bikes" only (e.g., Mountain Bikes, Road Bikes, Touring Bikes).
• Best for: Answering specific questions like, "What's driving our sales within the accessories category?"

2. Expand All Down One Level (The forked downward arrow)

This expands all categories at once to the next level down in the hierarchy.

• How to use it: Click the forked downward arrow icon. Your chart axis will change to show both the parent and child levels combined. For example, it might show "Accessories - Bike Racks," "Accessories - Locks," "Bikes - Mountain Bikes," etc., all on one concatenated axis.
• Best for: Seeing the breakdown of all categories at the same time on a single, expanded X-axis.

3. Go to the Next Level in the Hierarchy (The double downward arrows - old PBI versions)

This will move the entire chart down to the next level, aggregating the data from all parent categories. So, instead of seeing sales by Category, your entire chart will now display sales by Sub-Category. All sub-categories will be shown (not just from one category), and the data will be summed up. This button is often combined with the first these days.

4. Drill Up (The single upward arrow)

This does exactly what you'd expect. After you’ve drilled down, this icon becomes active. Click it to move back up one level in the hierarchy.

Method 2: Using the Right-Click Menu

For many users, right-clicking on a data point is even more intuitive.

1. Hover over a data point (like the "Clothing" column).
2. Right-click to open the context menu.
3. You'll see options to "Drill down" or "Show next level." This gives you easy access to navigate without hunting for the header icons.

This method works even without first "turning on" the drill-down mode in the header, making it quick and easy.

Advanced Functionality: Setting Up a Drillthrough Page

Sometimes, a simple drill-down doesn’t provide enough detail. You might start with a summary bar chart but want to drill into a full-page report showing a detailed data table for a specific product. This is where Drillthrough comes in.

Drillthrough allows you to link a visual on one page to a different page in your report, passing a filter along with it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to set up a Drillthrough

1. Create a Detail Page: First, create a new page in your Power BI report. This will be your drillthrough destination. You can name it something like "Product Details." Populate this page with visuals that provide granular information, like a table showing individual sales transactions, KPIs, or a map visualization.
2. Designate It as a Drillthrough Page: With the "Product Details" page selected (and no visuals selected on that page), go to the Visualizations pane. Find the Drillthrough field well at the bottom.
3. Add the Drillthrough Field: From your Fields pane, drag the category you want to filter by into the Drillthrough box. In our example, we want to drill through clicking on a product, so we'd drag Product Name here.

Once you do this, Power BI automatically adds a "Back" button to your detail page. This allows users to easily return to the page they came from.

Using the Drillthrough

Now, go back to your main summary page. Right-click on a data point that uses the field you selected for the drillthrough (e.g., the bar for a specific product, like "Mountain-200 Black").

In the context menu, you'll see a new option: Drillthrough → Product Details.

When a user clicks it, they are instantly taken to the "Product Details" page, which is now filtered to show only the data for the "Mountain-200 Black" product. It's a powerful way to provide deep contextual detail without cluttering your main dashboards.

Final Thoughts

Enabling drill-down and drillthrough functionalities is a game-changer for Power BI reports. It transforms your dashboards from static presentations of data into interactive, explorable tools that empower everyone to dig deeper and find answers on their own. By organizing your data into logical hierarchies, you give your numbers a story and a path for others to follow.

While Power BI's drill-down features are incredibly powerful, setting everything up across multiple visuals and integrating different data sources can still involve a steep learning curve. We built Graphed because we believe getting to these kinds of insights should be simpler. By connecting your marketing and sales data, you can build dashboards just by asking questions in plain English - no manual hierarchy configuration required. It’s an easier way to get to your insights in seconds, not hours.