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 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
Solved! Go to Solution.
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
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
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |