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 Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,364)