Forum Discussion

mail2vjj's avatar
mail2vjj
Helper III
8 years ago

Generate Columns Automatically for Hierarchy and PATH

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

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI mail2vjj

     

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

    • mail2vjj's avatar
      mail2vjj
      Helper III
      8 years ago

      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 :smileyvery-happy:

       

      Thank you,

       

      Vishesh Jain