Ravindra BagaleCourses & study guides मराठी Track your progress

17. Drill Through

17.2 Build the Target Page

By Last updated:

Quick answer: the short, self-contained version of this lesson is the guide Power BI Drill-through Pages.

Start with a problem

Shraddha wants a Store detail page that works from any chart that shows a city: cards on top, an order table below.

Explain simply

Build the target page once: drill-through field(s), visuals for detail, a Back button, and hide the page from normal navigation.

Show the data

Order ID Order Date City Store Platform Category Amount (₹) Delivery mins Status
301 06-Apr-2026 Pune Kothrud Blinkit Dairy 400 8 Delivered
302 06-Apr-2026 Pune Baner Amazon Now Snacks 200 12 Delivered
303 07-Apr-2026 Nashik Gangapur Blinkit Dairy 300 14 Delivered
304 04-May-2026 Nashik College Road Blinkit Fruits 150 9 Delivered
305 04-May-2026 Kolhapur Rajarampuri Amazon Now Snacks 450 7 Delivered
306 05-May-2026 Pune Kothrud Blinkit Fruits 250 16 Delivered
307 05-May-2026 Nashik College Road Amazon Now Dairy 350 11 Delivered
308 05-May-2026 Kolhapur Rajarampuri Blinkit Dairy 0 Cancelled

About this data: This table uses columns: Order ID, Order Date, City, Store, Platform, Category, Amount (₹), Delivery mins, Status. This table uses columns: Card / table, Pune (after drill through). This table uses columns: City, Total Sales. This table uses columns: Store, Total Orders, Total Sales. Values shown are the lesson examples already on this page (not a new dataset).

Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv (source: src/practice/).

Demonstrate

  1. New page › rename Store detail.
  2. Select a blank area › Build › Drill through › drag City into the well.
  3. Add cards: Total Sales, Total Orders, % Under 10.
  4. Add a table: Order ID, Store, Platform, Amount, Delivery Mins, Status.
  5. Check the auto-added Back button (top left).
  6. Right-click the page tab › Hide page.

Show the result

Your result should look like this (fictional sample):

Card / table Pune (after drill through)
Total Sales ₹850
Total Orders 3
% Under 10 33.3% (1 of 3: order 301)
Table rows 301, 302, 306

Explain what happened

Every visual on the target page receives the City filter, so cards and table all show Pune.

Explore further

  • Add a dynamic title: "Detail – " & SELECTEDVALUE(Orders[City]).

Detailed reference for this lesson:

Drill through in Power BI with example — in 30 seconds

What: Drill through opens a detail page for the item you right-click. The page is already filtered to that item.

Why: The overview shows all cities. The manager right-clicks Nashik and wants a page with only Nashik stores.

Tiny example: Right-click Nashik › Drill through › City Detail. The detail page shows only the 2 Nashik stores.

First look at the data (before → after):

Drill through in Power BI with example: before and after tables, fictional Blinkit Maharashtra data

Same before / after tables as text

Before — Overview page — sales by city

City Total Sales
Mumbai ₹1,100
Pune ₹1,000
Nashik ₹300

Formula / click path

City Detail page › Drill through well = DarkStore[City]
Overview › right-click Nashik › Drill through › City Detail

After — City Detail page (filter: City is Nashik)

Store Total Orders Total Sales
College Road 2 ₹200
Gangapur Road 1 ₹100

Do it step by step:

  1. Add a new page. Rename it City Detail.
  2. Add a table: Store Name, Total Orders, Total Sales.
  3. In Visualizations › Build, drag DarkStore[City] into Drill through.
  4. Check that a Back button appears at the top left.
  5. Go to the overview page. Right-click the Nashik bar. Click Drill through › City Detail.
  6. Check: only Nashik stores, total ₹300. Ctrl+click Back to return (in Desktop).

What appears on screen after these steps — sample layout, fictional data

What you should see on screen after the steps (sample layout — fictional data, not a Microsoft screenshot).

Steps in Power BI

  1. Add a new page (the + at the bottom). Rename it Dark Store Details (double-click the tab).
  2. Click an empty area of the canvas so no visual is selected. The Build visual pane now shows page-level wells including Drill through.
  3. Drag DarkStore[Store Name] into Add drill-through fields here.
  4. Power BI adds a Back button automatically at the top-left (if not, Insert › Buttons › Back).
  5. Build the detail visuals:
    • Cards: Total Orders, AOV, Avg Delivery Time (mins), % Orders Delivered Under 10 Mins, Cancellation Rate.
    • Line chart: Total Orders by Order Hour.
    • Bar chart: Orders by Delivery Partner (Amir, Raja, Salman …).
    • Table: Order ID, Order DateTime, Customer Name, Amount, Delivery Time Mins, Order Status (late orders first).
  6. Add a dynamic title such as "Dark Store Details – " & SELECTEDVALUE(DarkStore[Store Name]) (Module 20.2).
  7. Optional: right-click the page tab › Hide page, so users reach it only by drilling.

Target page tayar jhala! Aata pudhe jaauya drill-through options kade.

Ravindra Bagale's Tip

Friends, the mistake I see most is putting a field in the drill-through well that isn't in the source visual. For example, drilling through on Orders[City] while the source chart uses DarkStore[City]. Use the same dimension field on both, and hide the target page so users reach it only through drill through. Never forget this.

Fix common mistakes

Wrong result Reason Correction
Back button missing Deleted or not added in older version Insert › Buttons › Back
Hidden page still visible in the Service Not hidden before publishing Hide page and republish
Cards show totals of all cities Card uses a field from an unrelated table Check relationships

Practise independently

Practice task

What does the Kolhapur drill through show on the three cards?

Hints
  • 305 delivered in 7 min, 308 cancelled.
Solution

Total Sales ₹450, Total Orders 2, % Under 10 100% (1 of 1 delivered).

Think like a professional

One reusable detail page replaces many duplicate pages – easier to maintain and to secure.

Ravi Sir's Cards for this lesson

Build the target page. The target page must know which field to filter by.Revision card

मराठी cards