Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hierarchy Drill Down

I have 5 levels of hierrachy to drill down 




customer group

customer name



But When I click on "Drill Mode is on" and click on Region 

It is going to only 3 levels of dril down and stopped

Again I need to go to "Salescode " and right click Drill down 

After that again I need to go to "customer group" and right on Drill Down


I am not understanding what is the reason to the 3 levels of drill down and other 2 are not drill down 



Super User
Super User

Re: Hierarchy Drill Down

@Anonymous Could you please post the sample data for which you are facing this issue.  There is no such limitation for hierarchy levels that you are limited to drill-down.

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Not applicable

Re: Hierarchy Drill Down

America East



          GA Entertainment


America West 



         CSL Commissions

            CSL DEN


Is this good enough. There are 5 regions but stations and salescode, group and names are many

Community Support Team
Community Support Team

Re: Hierarchy Drill Down

Hi KKottha,

I can’t  reproduce your problem, I create a simple data like below, it will work well




So I am not sure which part cause this problem. If possible, could you please inform me more detailed information, such as your data structure ,  sample data and how you create this in powerbi and your current problem(by image or drawings)? Then I will try to reproduce this for you in my environment.

In addition, if you try to recreate the visual, will this work?

Best Regards,

Zoe Zhi

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)