Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
I have 3 tables and Need to create a hierarchy. Refer Screenshots attached
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |