Forum Discussion

mahitham's avatar
mahitham
Helper I
8 years ago
Solved

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)  C...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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/