Power BI Drill Through Feature Explained With Example

If you have ever looked at a summary chart in Power BI and wanted to click on one data point to instantly see all the detail behind it — drill through is exactly the feature you need.

Drill through is one of the most powerful navigation features in Power BI. It lets users right-click on a data point in any visual and jump directly to a dedicated detail page filtered to show only information about that specific item without building separate reports or applying manual filters.

In this guide, we will walk through everything you need to know about Power BI drill through — what it is, how to set it up step by step, a complete real-world example, and best practices for making it work beautifully in your dashboards.

What Is Drill Through in Power BI?

Drill through is a page-level navigation feature that allows users to right-click on a data point in a visual and jump to a separate report page that is pre-filtered to show detail about that specific item.

The key word is pre-filtered — when you drill through to a detail page, Power BI automatically applies a filter based on what you clicked. You do not have to set up slicers or manually filter anything. The context carries through automatically.

Simple Analogy

Imagine a summary dashboard showing total sales by product category. You see that Electronics had the highest sales. Drill through lets you right-click on Electronics and instantly jump to a detail page showing every individual Electronics transaction, product performance breakdown, regional split, and customer details filtered to Electronics only.

The summary page gives you the overview. The drill through page gives you the depth.

Drill Through vs Drill Down

These two features are frequently confused because they sound similar. They are completely different.

Drill Down — Navigates through a hierarchy within the same visual on the same page. For example, clicking from Year → Quarter → Month → Day in a date hierarchy on a bar chart. You stay on the same page, same visual.

Drill Through — Navigates from one report page to a completely separate detail page, filtered by the value you clicked. You leave the current page and land on a different page.

Feature	Drill Down	Drill Through
Navigation	Within the same visual	To a separate report page
Page change	Stays on same page	Moves to new page
Requires hierarchy	Yes	No
Filtered automatically	Yes (by hierarchy)	Yes (by clicked value)
Best for	Time, category hierarchies	Detailed record views

Real-World Example We Will Build

Throughout this guide we will build a complete sales reporting system with drill through.

Summary Page — Regional Sales Overview with total revenue by region displayed as a bar chart and map visual.

Drill Through Detail Page — Region Detail showing individual order breakdown, product performance, monthly trend, and top customers — all filtered to the region the user clicked on.

When a user right-clicks on “North” in the summary bar chart and selects drill through, they land on the Region Detail page showing only North region data.

Step 1: Set Up Your Data Model

For our example, we will work with a sales data model containing three tables:

Sales Table (fact table):

• OrderID, CustomerID, ProductID, RegionID, OrderDate, Revenue, Quantity

Regions Table (dimension):

• RegionID, RegionName, Country, SalesManager

Products Table (dimension):

• ProductID, ProductName, Category, UnitPrice

Make sure relationships are properly set up in the Model view — Sales connects to Regions and Products through their respective ID columns.

Step 2: Build the Summary Page

The summary page is where users start — the high-level overview.

Create the Summary Page

1. In Power BI Desktop, right-click the page tab at the bottom
2. Select Add Page
3. Double-click the tab and rename it “Regional Sales Overview”

Add the Summary Visuals

Bar Chart — Revenue by Region:

1. Click the Clustered Bar Chart visual in the Visualizations pane
2. Drag RegionName from Regions table to the Y-axis
3. Drag Revenue from Sales table to the X-axis
4. Format the chart with a clear title: “Total Revenue by Region”

Map Visual — Regional Performance:

1. Click the Map visual
2. Drag Country to Location
3. Drag Revenue to Bubble size
4. This gives executives a geographic view alongside the bar chart

KPI Cards: Add three card visuals showing Total Revenue, Total Orders, and Average Order Value across all regions.

Your summary page is now complete, a clean overview that will serve as the launch point for drill through navigation.

Step 3: Create the Drill Through Detail Page

This is the page users land on after drilling through. It must be configured to accept drill through filters.

Create the Detail Page

1. Right-click any page tab at the bottom
2. Select Add Page
3. Rename it “Region Detail”

Add the Drill Through Field — The Critical Step

This is what makes the page a drill through destination.

1. Make sure you are on the Region Detail page
2. Look at the Visualizations pane on the right
3. Find the Drill through section — it appears at the bottom of the Visualizations pane when no visual is selected (click on the blank canvas to deselect all visuals)
4. Drag RegionName from the Regions table into the Add drill-through fields here box in the Drill through section

As soon as you add a field here, two things happen automatically:

• A back arrow button appears in the top-left corner of the page allowing users to return to where they came from
• The page is now registered as a drill through destination for the RegionName field

Add Detail Visuals to the Page

Now build the detail visuals that appear when users drill through. All of these will automatically filter to the selected region.

Region Name Card:

• Add a Card visual
• Drag RegionName to the field
• This displays which region the user drilled into. This is essential for context

Monthly Revenue Trend (Line Chart):

• Add a Line Chart
• X-axis: OrderDate (set to Month level)
• Y-axis: Revenue
• Title: “Monthly Revenue Trend”

Order Details Table:

• Add a Table visual
• Columns: OrderID, OrderDate, CustomerID, ProductName, Quantity, Revenue
• This shows the individual transaction detail behind the summary number

Revenue by Product Category (Donut Chart):

• Add a Donut Chart
• Legend: Category (from Products table)
• Values: Revenue
• Title: “Revenue by Product Category”

Top 10 Customers by Revenue (Bar Chart):

• Add a Bar Chart
• Y-axis: CustomerID
• X-axis: Revenue
• Apply a Top N filter: Filter type = Top, Show items = Top 10, By value = Revenue
• Title: “Top 10 Customers”

Sales Manager Information (Card):

• Add a Card visual
• Drag SalesManager from Regions table
• Shows who owns this region

Your Region Detail page should now have rich, contextual information that tells the complete story of a region’s performance.

Step 4: Test the Drill Through

Go back to the Regional Sales Overview page to test.

1. Right-click on any region bar in the bar chart — for example, click on “North”
2. A context menu appears
3. Hover over Drill through
4. You will see Region Detail listed as a drill through destination
5. Click Region Detail

Power BI navigates to the Region Detail page. Every visual on the page is automatically filtered to show only North region data — the line chart shows North’s monthly trend, the table shows only North orders, the donut shows North’s product mix.

The back arrow in the top-left corner takes users back to the Regional Sales Overview page.

Step 5: Customizing the Back Button

The auto-generated back arrow button works but looks basic. Customize it to match your dashboard design.

1. Click the back arrow button on the Region Detail page to select it
2. In the Format pane:
   • Change button style — Filled, Outline, or with background
   • Change icon — Choose from Power BI’s icon library
   • Add button text: “← Back to Overview”
   • Set fill color and hover color to match your brand
3. You can also add a custom shape or image as the back button and set its Action to Back under the Format pane → Action settings

Step 6: Enabling Cross-Report Drill Through

By default, drill through only works within the same report file. Cross-report drill through lets users drill from one .pbix report to a detail page in a completely different report. This is powerful for large organizations with multiple report files.

Setting Up Cross-Report Drill Through

On the destination report (the detail page):

1. Go to the page with your drill through configuration
2. In the Drill through section of Visualizations pane
3. Toggle Cross-report to On

On the source report (where users click):

No additional setup needed — Power BI automatically enables cross-report drill through as an option when the destination page has it enabled.

Important: Both reports must be in the same Power BI workspace for cross-report drill through to work.

Step 7: Drill Through With Multiple Fields

You can add more than one field to the Drill through section — creating a more specific filter when users drill through.

Example — Product Category + Region Drill Through

Add both RegionName and Category to the Drill through fields section on your detail page.

Now users can right-click on a specific intersection in a matrix visual (North region, Electronics category) and drill through to see detail filtered by both North AND Electronics simultaneously.

Drill through fields:
- RegionName  ← carries the region filter
- Category    ← carries the category filter

Result: Detail page shows only North region Electronics orders

This is extremely powerful for multi-dimensional analyses where users need to slice by multiple dimensions simultaneously.

Step 8: Using DAX to Show the Drill Through Filter Context

Add a dynamic title to your detail page that shows exactly what was drilled into using DAX to read the current filter context.

Create a Dynamic Title Measure

Region Detail Title =
"Region Detail: " &
SELECTEDVALUE(Regions[RegionName], "All Regions")

1. Create a new measure with this DAX formula
2. Add a Card visual to the top of your detail page
3. Place this measure in the card
4. Format it as a large, prominent title

When users drill through from North → the card shows “Region Detail: North” When users drill through from South → the card shows “Region Detail: South”

This eliminates any confusion about which region the user is currently viewing.

Real-World Use Cases

Executive Sales Dashboard

An executive sees total revenue by region on the summary page. They notice the West region is underperforming. They drill through on West to see the detail page, instantly seeing which products are dragging performance, which customers have reduced purchasing, and which months showed the steepest decline. All without leaving Power BI or asking an analyst to run a query.

HR Analytics

A workforce overview shows headcount by department. An HR manager drills through on Engineering to see individual employee details — tenure, performance ratings, salary bands, and attrition risk scores — filtered automatically to Engineering only.

Financial Reporting

A P&L summary shows expenses by cost center. A finance director drills through on Operations to see individual transaction details, vendor breakdown, budget vs actual comparison, and month-over-month trend — all filtered to Operations automatically.

Customer Analytics

A customer segment overview shows revenue by customer tier. A CRM manager drills through on the Premium tier to see individual customer profiles, purchase history, lifetime value, and churn risk — filtered to Premium customers only.

Drill Through Configurations

Configuration	Use Case	Complexity
Single field drill through	Filter detail by one dimension (Region)	Easy
Multi-field drill through	Filter by two+ dimensions simultaneously	Moderate
Cross-report drill through	Navigate between separate report files	Moderate
Dynamic title with DAX	Show current filter context on detail page	Easy
Custom back button	Branded navigation experience	Easy
Drill through + bookmarks	Complex navigation flows	Advanced

Common Mistakes to Avoid

• Adding the drill through field to a visual instead of the Drill through section — The drill through field must go into the Drill through section at the bottom of the Visualizations pane — not into a chart or table. Click the blank canvas to deselect all visuals, then drag the field to the Drill through section
• Using the wrong field type — The field you add to Drill through must match the field in the visual users click on. If your bar chart uses RegionName, your drill through field must also be RegionName — not RegionID
• Not adding a back button — Power BI adds one automatically but users may not notice it. Make it prominent and clearly labeled so users know how to return to the summary page
• Building the detail page without testing the filter — Always test drill through from an actual visual before sharing with stakeholders. Verify that every visual on the detail page responds correctly to the filter
• Forgetting to rename the detail page clearly — The page name appears in the drill through context menu. “Page 2” tells users nothing. “Region Detail” or “Customer Deep Dive” makes the navigation intuitive
• Over-crowding the detail page — The detail page should tell a complete story about the drilled item — but too many visuals become overwhelming. Focus on the five to seven most important pieces of information

Drill through transforms Power BI reports from static summaries into truly interactive analytical tools — where executives and analysts can move seamlessly from high-level overview to granular detail in a single click.

Here is a quick recap of everything we covered:

• Drill through navigates from a summary page to a detail page filtered by the clicked value
• Add the drill through field to the Drill through section in the Visualizations pane — not to a visual
• The back button is created automatically — customize it to match your design
• Use PARTITION BY equivalent in DAX (SELECTEDVALUE) to create dynamic page titles
• Multiple fields in the Drill through section enable multi-dimensional filtering
• Cross-report drill through connects detail pages across separate report files

Start with the single-field drill through, test it thoroughly, and then layer in dynamic titles, custom back buttons, and multi-field configurations as your reports grow in sophistication.

FAQs