Your treemap now shows the postal code for your store in Knoxville. Let's continue to drill down one field at a time. Your treemap now shows all the cities and territories in Tennessee that have a store.ĭrill down for a particular city in Tennessee. Instead, it will cross-filter the other charts on the report page. If you don't turn on the drill-down option, selecting a visual element (like a bar, bubble, or leaf) won't drill down. Examples of visual elements are: bar, bubble, and leaf. Now you have the option of drilling down one field at a time by selecting a visual element. Select the drill-down icon to turn it on. Each step in the path shows you the same information and adds on one level of new information. The next drill adds postal code data for both KY and TN, and keeps city data as well. Your first drill adds city data for both KY and TN. So if you're looking at the Territory level, you can expand all current leaves in the tree at the same time. Expand all fields at onceĮxpand adds an additional hierarchy level to the current view. Select the drill-up icon until you get back to "Total units this year by territory". Each step in the path shows you new information.
If you're looking at the Territory level for Kentucky and Tennessee, you can drill down to city level for both states, then postal code level for both states, and, finally, the store name level for both states.
Selecting the double arrow drill-down icon takes you to the next level in the hierarchy. You have several ways to drill into your visual. Second way: right-click a visual to reveal and use the menu.ĭrill pathways Drill down all fields at once The grey background lets you know that the drill-down option is active. Turn on the drill-down feature first by selecting the downward arrow. Try them both, and use the one that you enjoy the most.įirst way: hover over a visual to see and use the icons. You have two ways for accessing the drill-down, drill-up, and expand features for visuals that have hierarchies. Territory is the top level of the hierarchy. The treemap, before drilling, looks at total units sold this year by territory. In this example we're using a treemap that has a hierarchy made up of territory, city, postal code, and store name. If you see a combination of these drill controls at the top, your visual has a hierarchy. Not sure which Power BI visuals contain a hierarchy? Hover over a visual. A common date hierarchy is one that contains year, quarter, month, and day. Report designers often add date hierarchies to visuals. Selecting the diving element would show you details for springboard, platform, and synchronized diving events.ĭates are a unique type of hierarchy. Selecting the aquatics element would show you data for swimming, diving, and water polo. But, because it has a hierarchy, selecting one of the visual elements (like a bar, line, or bubble), would display an increasingly more-detailed picture. By default, the visual would show medal count by sport: gymnastics, skiing, aquatics, and so on. For example, you might have a visual that looks at Olympic medal count by a hierarchy made up of sport, discipline, and event. When a visual has a hierarchy, you can drill down to reveal additional details. Using drill down and drill up on your data points, you can explore in-depth details about your data.
This article shows how to drill down in a visual in the Microsoft Power BI service.
APPLIES TO: Power BI service for business users Power BI service for designers & developers Power BI Desktop Requires Pro or Premium license