Creating Hierarchies in Power BI

By Imran Burki | November 30, 2017

Creating hierarchies in power bi

One of the cool features in Power BI is that it allows you to create your own hierarchies. When a visual has a hierarchy, it enables the ability to drill down for additional relevant details. For example, you might have a visualization that shows the product hierarchy with revenue and you want to drill down on a specific product that is under-performing. By drilling down, you’re able to see the elements that make up the product and pin-point exactly what product or products are causing the decrease in revenue.

In this post we’ll cover how easy it is to create hierarchies in Power BI using the example above.

Levels that comprise a hierarchy in Power BI.
1) Before we build a hierarchy, we’ll need to know the levels that comprise the hierarchy. In our example, the levels are Category -> Subcategory -> Product -> Product Image URL.

2) After we know the hierarchy levels, we’ll use simple drag/drop techniques to create the hierarchy. Since Category is our first level in the hierarchy, let’s look for Subcategory and place it right on top of Category. Notice that there is a new item was created called “Category Hierarchy.”

Use drag and drop techniques to create hierarchies in Power BI.

3) Finally, we’ll drag and drop Product, and Product Image URL on the Category Hierarchy we just created and rename Category Hierarchy to Product Hierarchy by right-clicking Category Hierarchy and selecting “Rename.”

Renaming hierarchies in Power BI.
4) Now that our hierarchy is created, we can see it in action. In the top right-hand corner, we have a bar chart named “Sales Amount by Category” where the drill actions will take place. There are two methods to drill up/down. First, you can right-click on a bar and drill down or you can turn drill down on. By turning drill down on, we’ll be able to drill down on a level by clicking on it rather than doing a right click. My personal preference is to turn drill down on.

Two methods to drill up/down in Power BI.

5) To turn drill-down on, click on the chart and click on the down arrow in the top right-hand corner of the chart. Once enabled, the down arrow will have a black background.

6) We see that “Arts and Crafts is our lowest performer in terms of sales. To drill down on that item, simply click on it and the chart will immediately go to the next level.

Click on the lowest performer in Power BI to drill down to the next level.

7) To drill back up you can right-click any bar and select “Drill Up” and the report will go back up one level.

To drill up on level on Power BI, right-click on any bar and select "drill up."

Drilling up/down allows us to slice and dice our data to uncover patterns and anomalies. In this short demonstration, we saw how easy it is to create a hierarchy in Power BI and enable drill up/down functionality.

Related Posts

Recommended Reading:

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X