Forum Discussion
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
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
2 Replies
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/
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