Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |