Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 | |
102 | |
85 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |