Generate Columns Automatically for Hierarchy and PATH

[mail2vjj]

Hi everyone,

I am working on a Hierarchy related PBI file and I have run into an issue.

I have created columns for every Level in the Hierarchy, but when a new level is introduced, everytime I have to manually generate another column.

As you can see I have generated a new column for every level of the hierarchy.

I want these columns generated automatically, so that every time a new level is added a new column gets added automatically.

Is there some way this can be done in Power Query as I am quite sure, this cannot be done using DAX.

Apart from that, I have also created a hierarchy based on these different level columns.

Is there some way this hierarchy is created automatically as well, from the level columns which are created automatically.

The PBIX and Excel files are in the OneDrive link below:

https://1drv.ms/f/s!Ap0qSKP-4qpThCc1sSXanmibgIff

I am open to other suggestions or solutions from the any one has anything.

It would be great if someone can please help me with this.

Thank you,

Vishesh Jain

[Phil_Seamark]

HI @mail2vjj

What are you actually using the Hierarchy for?  Is it to control drill up/down behavior for visuals?

[mail2vjj]

Hi @Phil_Seamark,

I am trying to create a Hierarchy system for the sales team in my organization.

This way I can monitor every team.

Consider it like a ponzi scheme, but it is nothing fradulent 

Thank you,

Vishesh Jain