Forum Discussion
Solved
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...
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.
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.