# How to Drill-Down in Power BI

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-drill-down-in-power-bi/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3c1bab56e05a00fe398e/preview?step=1

## Steps

1. Let's open the Power BI report where you want to create your drill-down functionality.
2. In the 'Fields' pane, find your date field and check the box to enable the 'Date Hierarchy' (Year > Quarter > Month > Day).
3. Now, click on the 'Visualizations' pane on the right side of your screen.
4. Select a visual type that supports drill-down functionality - charts like bar, column, line, or tables work great for this.
5. 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).
6. Nice work! Your drill-down is now active. Try clicking on a data point to drill deeper into your hierarchy levels.