cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Hierarchy Drill Down

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 

 

 

3 REPLIES 3
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 !





Anonymous
Not applicable

Re: Hierarchy Drill Down

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

Highlighted
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

 

3.png

 

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

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

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 (4,616)