Forum Discussion

lance_6's avatar
lance_6
Helper II
5 years ago
Solved

Automatic Hierarchy Creation

Issue: 

I want power bi to automatically add levels to a hierarchy so I can use this more effectively within a template. 

 

Background:

I am creating a template to be used by multiple organizations; each structured slightly different from the other. 

All have a parent child hierarchy. But there is a range for depth/levels. Some have 2, some have 22.

 

Data structure:

 

I was able to dynamically flatten the hierarchy with query editor (article on how to dynamically flatten parent-child hierarchy). Is there is a way to dynamically create the hierarchy from here, rather than expecting end users to manually create this for their organizations(it'd only be like 4 clicks to add each level, but not ideal)? 

 

Current Process To Create Hierarchy:

1. Right click level 1 > 2. Click create hierarchy > 3. Right click level 2 > 4. Click add to hierarchy > 5. Click <my hierarchy name> > 6. Right click level <#> > 7. Click add to hierarchy > 8. Click <my hierarchy name> > 9. Repeat steps 6-9 for each additional level

 

Thank you in advance for reading my post!

 

 

  • Hi lance_6 

     

    I don't find any option or workaround to create a custom hierarchy automatically. It seems not supported in Power BI Desktop at present. 

     

    Regards,
    Community Support Team _ Jing

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support

    Hi lance_6 

     

    I don't find any option or workaround to create a custom hierarchy automatically. It seems not supported in Power BI Desktop at present. 

     

    Regards,
    Community Support Team _ Jing

    • lance_6's avatar
      lance_6
      Helper II

      That's what I've found so far as well. I submitted it for a new idea and am hoping to have it added at some point. Thank you for your research and help.