Forum Discussion
Hierarchies within different column tables
Hi, I am familiar with hierarchies, but now I have the need to create a new hierarchy based on description from different tables: Products Hierarchie, but I need the hiest level of manufacturer which description is in the Manufactureres Table, and then a Category level which description is in other Table (Categories). Now, in Power BI I can just create Hierarchies in a Table with columns from the same table, how can I solve this? Any advice is welcome
Hi macostaf2,
You can bring the related fields into the table with the lowest level of granularity, which can be done on this table by adding calculated columns as demonstrated by the following example, then you are able to create hierarchy.
ColumnName=RELATED(DimProductSubcategory[EnglishProductSubcategoryName])
For more details, please check the following blog.
https://intelligentsql.wordpress.com/2013/05/08/tabular-hierarchies-across-multiple-tables/
Thanks,
Lydia Zhang
1 Reply
Hi macostaf2,
You can bring the related fields into the table with the lowest level of granularity, which can be done on this table by adding calculated columns as demonstrated by the following example, then you are able to create hierarchy.
ColumnName=RELATED(DimProductSubcategory[EnglishProductSubcategoryName])
For more details, please check the following blog.
https://intelligentsql.wordpress.com/2013/05/08/tabular-hierarchies-across-multiple-tables/
Thanks,
Lydia Zhang