Hierarchy Drill Down

[Anonymous]

I have 5 levels of hierrachy to drill down 

Region

station

Salescode

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 

[PattemManohar]

@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.

[Anonymous]

America East

   ATL

       1AAASS

          GA Entertainment

               GAPartyName

America West 

  DEN

     1DENRR

         CSL Commissions

            CSL DEN

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

[dax]

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