Quick summary
Drill-down in Power BI lets you explore data across hierarchy levels — such as Year, Quarter, Month, and Day — directly within a visual. By enabling Date Hierarchy and using the drill controls on supported chart types, you can give report viewers deeper, on-demand data insights.
Steps
- 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).
- Click on the Visualizations pane on the right side of your screen.
- Select a visual type that supports drill-down — such as a bar, column, line chart, or table.
- Click on your visual to select it, then locate the drill controls in the top-right corner and click the Drill Down icon (the forked arrow pointing downward).
- Click on a data point to drill deeper into your hierarchy levels and explore granular data.
