How to Drill-Down in Power BI

George Apostolov
Updated 05 Oct 2026
- ▣ Power BI

This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free

How to Drill-Down in Power BI: step-by-step guide

Let's open the Power BI report where you want to create your drill-down functionality.
In the 'Fields' pane, find your date field and check the box to enable the 'Date Hierarchy' (Year > Quarter > Month > Day).
Now, click on the 'Visualizations' pane on the right side of your screen.
Select a visual type that supports drill-down functionality - charts like bar, column, line, or tables work great for this.
Click on your visual to select it. Look for the drill controls in the top-right corner - they look like tiny arrows. Click the 'Drill Down' icon (the one with a forked arrow pointing downward).
Nice work! Your drill-down is now active. Try clicking on a data point to drill deeper into your hierarchy levels.

Quick answer: To drill-down in Power BI, open your report, enable the Date Hierarchy in the Fields pane, select a compatible visual type, activate the drill-down icon in the top-right corner, and click a data point to explore deeper hierarchy levels.

About this Power BI tutorial

Activate drill-down functionality in Power BI reports by enabling date hierarchies, selecting visuals, and using drill controls. This guide shows how to drill-Down in Power BI in 6 steps, starting with "Let's open the Power BI report where you want to create your drill-down functionality" and finishing with "Nice work! Your drill-down is now active. Try clicking on a data point to drill deeper...". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.