Hierarchy with Matrix table - Cant get the ideal hierarchy.

[Anonymous]

Fellow Bi'ers

Im trying to create a hierachy matrix table in Power BI. This hierachy is simplified in the table down below.

Department	Parent dep 2	Parent dep 3	parent dep 4	Value
Amsterdam store	Holland	Europe	Europe	1
Food (Amsterdam store)	Amsterdam store	Holland	Europe	5

Just to make sure - Value is part of the 'Department' column. So department 'Amsterdam store' is a parent department in the next row.

When i create a matrix in Power BI, this is the result

Now the dream scenario would be to have 1 hierarchy - with those 2 values.

Instead the results of the table shows a double hierarchy, which is understandable, just not what i want ( especially with 500 rows for example).

Are there any tips and tricks to achieve 1 hierarchy - with ALL values.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Do you want the following hierarchy? Just change the order of the fields.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.