Customers wish to see your dashboard visuals, however in addition they wish to see the underlying particulars. As an example, a visualization of gross sales by nation shows good info. Nonetheless, your customers may even wish to see gross sales for particular cities inside a rustic and even prospects inside a metropolis. Relationships make this doable, and hierarchies maintain ranges constant when drilling.
On this tutorial, I’ll present you the right way to create a hierarchy that helps drill mode in Energy BI. After you have that hierarchy, you may rapidly construct visualizations that assist drilling. At one time this was tedious work, however now it’s just a few clicks. You’ll study what a hierarchy is, why you would possibly want one and the right way to construct one once you do.
I’m utilizing Microsoft Energy BI Desktop on a Home windows 10 64-bit system. You too can use Energy BI service, although you’ll want a Professional or Premium license. You possibly can obtain the Microsoft Energy BI demo file for this tutorial.
SEE: Microsoft Energy Platform: What it is advisable to learn about it (free PDF) (TechRepublic)
Find out how to decide if you happen to want a hierarchy in Energy BI
If customers wish to see particulars, you’ll each profit from a hierarchy. A hierarchy is a fast manner so that you can fulfill drilling necessities and the person will all the time see the drill ranges in the identical order.
A hierarchy is a set of fields structured by ranges. The hierarchy has a mum or dad stage and from there customers can drill down by the decrease ranges, which include particulars concerning the mum or dad. The hierarchy requires a minimum of two ranges, a mum or dad and a set of particulars, however a hierarchy can include many ranges.
SEE: Hiring equipment: Microsoft Energy BI developer (TechRepublic Premium)
You could possibly construct particular person visualizations for every stage and use filters to synchronize updates, however a hierarchy is faster and simpler. Briefly, a hierarchy permits customers to discover information in a constant method. Creating the visualization manually may even allow drill mode, however after you have a hierarchy, all visualizations based mostly on that hierarchy will likely be constant and user-friendly.
Determine A reveals two visualizations based mostly on the identical tables within the Journey Works DW 2020 (v1) Energy BI Desktop pattern mannequin. This mannequin accommodates a hierarchy within the Gross sales Territory desk. I based mostly the visualization on the left on the hierarchy and added the Gross sales Quantity discipline from the Gross sales desk. I constructed the visualization on the correct manually. Each assist drill mode.
Determine A
Initially, the 2 visualizations look like the identical, however seems to be are deceiving. Word the order of the fields within the hierarchy within the X-axis bucket: group, nation and area. The Gross sales Quantity discipline is within the Y-axis bucket. The drill buttons are under the visualization, and the black circle signifies that drill mode is on.
Determine B reveals what occurs once you click on the double-arrow button, which drills all the way down to the subsequent stage. They’re not the identical, which could be a little bit of a shock to your finish customers in the event that they’re used to seeing particulars in a unique order.
Determine B
The visualization to the correct is in nation, group, area order. Which means the mum or dad ranges aren’t the identical. Irrespective of how the top person drills, the expertise gained’t be the identical because the one constructed on the hierarchy. In truth, the one to the correct is a bit deceptive as a result of it seems to assist the nation stage because the mum or dad stage. We are able to clearly see through the use of the hierarchy that the mum or dad stage is the group stage, a minimum of within the hierarchy.
The person ought to have the identical drilling expertise from one visualization to the subsequent. That’s why you’ll wish to create a hierarchy for drilling. Apart from, it makes your work a bit simpler.
Find out how to add a hierarchy in Energy BI
The demonstration file for this Energy BI tutorial already has a hierarchy within the Gross sales Territory desk. That hierarchy is in group, nation, area order, which you noticed earlier. Let’s add one which’s in nation, group, area order. Most probably, you wouldn’t add this second hierarchy, however it’s a good way to match the variations.
So as to add a hierarchy, click on Mannequin within the navigation pane to the left. Then, browse round till you discover the Gross sales Territory desk. The icon to the left of Gross sales Territories identifies the group of fields as a hierarchy.
So as to add a brand new hierarchy with nation because the mum or dad stage to the Gross sales Territory desk, right-click the Nation discipline, the mum or dad discipline, and select Create Hierarchy from the ensuing menu (Determine C).
Determine C
Within the Common pane to the correct, enter a brand new title for the hierarchy, Gross sales Territories Nation Dad or mum, on the prime of the pane.
From the Choose A Column To Add dropdown, select Group. Energy BI provides the mum or dad discipline, Nation, for you.
From the identical dropdown, select Area (Determine D).
Determine D
Click on the Apply Degree Adjustments hyperlink under the Area discipline.
If you return to the Report window, you can find the brand new hierarchy within the Fields pane, as proven in Determine E. You now have two hierarchies on which to construct visualizations. A desk can have a couple of hierarchy, however you’d most likely not construct two that merely reorder a few fields.
Determine E
Customers most likely gained’t know you’re utilizing a hierarchy, so the visualizations persistently present drill ranges in the identical order throughout all visualizations. Nonetheless, they could discover if you happen to don’t and never in a great way.