How to create Hierarchy

[mahitham]

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

[Anonymous]

I have 3 tables and Need to create a hierarchy. Refer Screenshots attached TablesNew 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/

[Anonymous · Accepted solution]

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