How to Drill-Down in Power BI

‍

‍

Here’s how to do it:

‍

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.