Drill-through and Drill-down
Implementing drill-through and drill-down features to explore data details
3. Drill-Down Functionalities
• What is Drill-Down? Drill-down allows users to explore data at different levels of detail. For example, you can start with yearly sales data and then drill down to see sales by month or even by day.
How to Enable Drill-Down?
1. Create a hierarchy by dragging Category and ProductName in same field.
2. Select a visual (like a bar chart) and click on the Drill Down button (a small downward arrow) in the visual’s header.
3. Users can click on double downward arrow to go next level of hierarchy i.e. Product name.

4. Below we can see Sales by Product name. If we again want to come on first level of hierarchy i.e. Category, we have to click the Upward arrow.
Drill Through
Drill Through in Power BI lets you dive deeper into your data. It’s a feature that allows you to click on a data point in your report and go to another page with more detailed information about that data.
What is Drill Through?
Drill through lets you focus on specific data by going from one page of your report to another page that shows more details. For example, if you are looking at total sales for different regions, you can click on one region and “drill through” to another page that shows detailed sales for that region.
Why is Drill Through Useful?
• Gives More Detail: You can create summary reports on one page and detailed reports on another. Drill through helps
you jump from one to the other easily.
• Saves Time: Instead of showing everything on one page, you can organize your data across different pages and drill
through to find what you need.
How Drill Through Works:
1. Main Page Setup: Create a bar chart that shows total sales by region using data from the Customers Table (Region)
and Sales Table (SalesAmount). You’ll see regions like North, East, West, Central, and South with their respective
sales totals.
2. Drill Through Page Setup: On a new page, create a table that shows detailed sales information using data from all three tables:
o Product Name from the Products Table
o SalesAmount and Quantity from the Sales Table
o Customer Name from the Customers Table
3. Drag Region (from the Customers Table) into the Drill Through field in the Drill Through Pane.
4. On the Main Page, right-click on a bar representing a region, such as “North.” Select Drill Through to go to the Drill through page page.
5. The page will now show detailed sales data specifically for the North region, including all the products sold, sales amounts, and customers from that region.
• The Drill through page will now show detailed sales data specifically for the North region, including all the products sold, sales amounts, and customers from that region.
Course Video
YouTube Reference :
Drill through in Power BI allows users to right-click on a data point in a visual and navigate to a detailed report page that focuses on that specific data point, enabling deeper analysis.
Drill through allows users to navigate to another page with detailed insights based on a specific data point (e.g., by right-clicking a region to see detailed sales for that region).
Slicer is a filter that applies across visuals on the same page, allowing users to filter the entire page by specific criteria like date, category, etc.
1. Create a Drill Through Page: Add a new report page and set up visuals that will be filtered by the drill through.
2. Set Drill Through Fields: Drag the field you want to drill through into the Drill-through well in the Visualizations pane.
3. Enable Drill Through: Right-click on a data point in a visual on the original page and select the target report page to drill through to.
To drill down from one visual to another on the same page, simply click on a visual element to drill down to more detailed levels (e.g., click on a region to see data by city).
For cross-page drill down, you can set up drill-through to jump between pages.
A drill-through from a report to a report allows users to navigate from one report page to another that provides more detailed data about a specific data point. It’s useful for deeper analysis on related data.