Forum Discussion
Multi column hierarchy
Hello all,
can somebody tell me how to create a hierarchy which has multiple columns per level in Power BI?
It is not usual as year/quarter/month/day but it has something like this:
BV - BY are all excel columns, and BZ - CE are also columns, you know, these things at the end:
thanks
Hi Vashko
It can not directly created a hierarchy relared to manyt columns , you need to unpivot the columns first , then add a column to juge which is belong to leve1 and which is bloing to level 2
e.g
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Vashko
It can not directly created a hierarchy relared to manyt columns , you need to unpivot the columns first , then add a column to juge which is belong to leve1 and which is bloing to level 2
e.g
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.