Drill Through

Drill Through in Power BI allows users to navigate from a summary report to a detailed report page for more in-depth analysis. It helps users explore data dynamically and focus on specific items without cluttering the main report.

Drill Through is commonly used for metrics like sales by region, product performance, or customer details.

Key Concept

Drill Through works by passing filters from one page to another. When a user right-clicks a value in a visual, Power BI filters the target page based on that selection.

Steps to Create Drill Through

Step 1: Create a Target Page

1. Add a new page in your Power BI report.
2. Design the page to show detailed data (e.g., a table with transactions, a chart with product details).

Step 2: Add Drill Through Fields

1. In the Visualizations pane, find the Drill Through section.
2. Drag the field you want to use for drill through (e.g., Product, Customer, Region) into the Add drill-through fields here box.

Step 3: Add a Back Button

• Insert a Button → Format → Action → Type: Back
• This allows users to return to the original summary page easily.

Step 4: Test Drill Through

1. Go to the summary page.
2. Right-click a value in a visual (e.g., a specific product).
3. Select Drill Through → Target Page.
4. The target page opens with all visuals filtered based on the selected value.

Example

• Summary Page: Total Sales by Region
• Drill Through Page: Detailed Sales Transactions for the selected Region

When a user clicks on “North Region,” the drill-through page automatically shows only North Region’s sales transactions.

Best Practices

• Use one or two key fields for drill-through to keep it simple.
• Design the drill-through page with clear visuals and tables.
• Include a back button for easy navigation.
• Make titles dynamic using DAX to show which item the drill-through is filtered by.

Dynamic Title Example

DrillThroughTitle = 
"Sales Details for " & SELECTEDVALUE(Region[RegionName], "All Regions")

• This updates the page title based on the drilled value.

Conclusion

Drill Through in Power BI enhances report interactivity and allows users to explore detailed insights without overwhelming summary pages. It is a powerful feature for building professional, interactive, and user-friendly dashboards.