cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

How to create Hierarchy

Hi,

 

I am new to pwer bi. I have found below hierarchy i.e., BUHierarchy with BU and Division Columns in the sample app(https://docs.microsoft.com/en-us/power-bi/sample-customer-profitability)

 Can any one pleas let me know how to and where to  create this hierarchy and what is the purpose of hierarchy. 

Thanks in advance

 

Hierarchy.png

1 ACCEPTED SOLUTION
Resident Rockstar
Resident Rockstar

In the fields pane, If you drag city field onto country field, the hierarchy will be created. This is how you will create hierarchy.

 

Hierarchy is useful to implemet drill functionality . SAy for ex: if you create a chart with this country Hierarchy with sales measure, Sales by country will be displayed with the option to drill down to sales by city.

 

Hope this is clear.

 

Thanks

Raj

View solution in original post

2 REPLIES 2
Post Patron
Post Patron

I have 3 tables and Need to create a hierarchy. Refer Screenshots attached TablesTablesNew ColumnsNew Columns

1-Create column ProductSubCategory in Product table: ProductSubCategory = RELATED(DimProductSubcategory[EnglishProductSubcategoryName])

 

2-Create column ProductCategory in Product table: ProductCategory = RELATED(DimProductCategory[EnglishProductCategoryName])

 

3-Create Hierarchy by Dragging and Dropping these columns to EnglishProductName.

 

https://business-insights.net/2017/09/02/the-magic-of-related-relatedtable-functions-in-dax/

Resident Rockstar
Resident Rockstar

In the fields pane, If you drag city field onto country field, the hierarchy will be created. This is how you will create hierarchy.

 

Hierarchy is useful to implemet drill functionality . SAy for ex: if you create a chart with this country Hierarchy with sales measure, Sales by country will be displayed with the option to drill down to sales by city.

 

Hope this is clear.

 

Thanks

Raj

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors