cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
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
Highlighted
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

Highlighted
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/

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors