Showing results for 
Search instead for 
Did you mean: 
KKottha Frequent Visitor
Frequent Visitor

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

@KKottha 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 !

KKottha Frequent Visitor
Frequent Visitor

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

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 149 members 1,755 guests
Please welcome our newest community members: