Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |