Forum Discussion
Create a Hierarchy from Different Tables
I am attempting to create a hierarchy so I can include multiple row hierarchies (containing 3 categories) and one instance of a column hierarchy (containing 3 categories) in a matrix. However, it seems I can only create a hierarchy composed of values within one, single table. Is it possible for me to pull values from multiple tables into one hierarchy? Or would I have to merge my tables so all of the values that I want to pull are contained in one table.
Thanks in advance!
There are two ways of creating a hierarchy in power BI. You can create a configured hierarchy that stays a permanent part of the table structure, or an ad hoc hierarchy which is configured just for the visual. The former must be done inside a single table and the latter can take columns from any table
2 Replies
There are two ways of creating a hierarchy in power BI. You can create a configured hierarchy that stays a permanent part of the table structure, or an ad hoc hierarchy which is configured just for the visual. The former must be done inside a single table and the latter can take columns from any table