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.
POWER DRILL HOW TO
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
0 kommentar(er)
