Power BI Drill Down and Drill Up
Drill down lets readers move from a broad summary to finer detail inside the same visual. A chart that begins with yearly sales can reveal quarters, months, and days with a few clicks. Drill up reverses the journey.
The Map Zoom Analogy
A digital map starts with a country view. Zooming in shows states, then cities, then streets. Zooming out returns to the wide view. Drilling works the same way on a hierarchy of fields.
Country ==> State ==> City ==> Street (zoom in = drill down) (zoom out = drill up)
Building a Hierarchy
A hierarchy is an ordered list of fields. Power BI builds date hierarchies automatically, and you can create your own for products, locations, or organizations.
- Place fields in the Axis well of a chart in the order you want, such as Category, then Subcategory, then Product.
- Alternatively, right-click a field in the Data pane and choose Create hierarchy.
- Drag extra fields onto the new hierarchy to add levels.
A hierarchy that lives in the model is reusable across every report page.
The Drill Controls
Hover over a chart that has a hierarchy and a row of icons appears in the top corner.
| Icon | Action |
|---|---|
| Up arrow | Drill up to the previous level |
| Single down arrow | Turn on drill mode, then click a data point to drill into it |
| Double down arrow | Go to the next level for all data points |
| Forked arrow | Expand all down one level and show both levels together |
Drill Mode Versus Next Level
Drill mode on, followed by a click on one bar, shows only that bar's children. The double down arrow shows the next level for every bar at once. Pick drill mode for focused exploration and next level for a full overview.
Level 1: Furniture Electronics Clothing
|
(click Electronics in drill mode)
v
Level 2: Phones Laptops Cameras
Expand Versus Drill
The forked arrow keeps the higher level visible. Axis labels combine both levels, such as Electronics Phones and Electronics Laptops. Expand suits comparisons that need parent and child names side by side.
Drill Down and Cross-Filtering
Drilling changes only the visual in use. Other visuals on the page do not react. Cross-filtering, in contrast, begins when a reader clicks a data point without drill mode, and every other visual then filters to that selection.
Worked Example: Sales by Date Hierarchy
A line chart shows revenue per year with the Date hierarchy in the Axis well. A reader notices a spike in 2025 and clicks the double down arrow. The chart now shows quarters across all years. Another click shows months. The reader spots that November drove the spike, then clicks the up arrow to return to the yearly view.
Tips for Smooth Drilling
- Order levels from broad to narrow.
- Limit hierarchies to three or four levels.
- Use clear field names so axis labels make sense at every level.
- Test the experience in Reading view as a viewer would.
Key Points
- Drill down moves from a summary to detail inside one visual.
- Hierarchies list fields from broad to narrow.
- Three drill controls cover single data points, whole levels, and expansion.
- Drilling affects only the chosen visual and leaves others untouched.
- The up arrow restores the previous view.