Automatic Hierarchy Creation

[lance_6]

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!

[v-jingzhang · Accepted solution]

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]

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.