Creating Custom hierarchy or custom grouping

[BlackCat]

I have to create a custom hierarchy to update "Revenue By Business Unit" chart below and to allow for drill up/down at all levels of the Company business hierarchy. Basically drilling down from Business Unit to Division. Business Unit being:

• Health
• IT
• Learning
• Advanced tech

Any assistance with this is appreciated

[v-eqin-msft · Accepted solution]

Hi @BlackCat ,

You want to create a hierarchy, right?Please take a look at this blog for reference: https://spreadsheeto.com/power-bi-hierarchy/

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin