Multi column hierarchy

[Vashko]

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

[Anonymous · Accepted solution]

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.