Forum Discussion

ngadiez's avatar
ngadiez
Helper II
9 years ago
Solved

Drill Down Problem

I have 3 level or hierarchy for my bar chart. It will show the y axis, which is my data and x axis the amount.   When I drill down, normally I will see the next level data in my y-axis. Now I wil...
Need Help
  • ngadiez's avatar
    ngadiez
    9 years ago

    Hi Angelia,

     

    Thank you so much for your reply.

    However, I don't want the result shown in the third screenshot.

    If we click the 'Expand all down one level in the hierarchy' I will get the third screenshot. That one I aware.

    However now, when I right-click the bar and select drill down on the second screenshot. I get this third screenshot where I don't want. 

    ie. When I right click and drill down China I get China Beijing, China Shanghai, etc. This one should happen when I click the third button from the left.

     

    What I want when I drill down China, is to get Beijing, Shanghai, etc only.

     

    Thank you so much.

     

    I believe there is a bug.

     

     

    Edit: when I retry new chart with same data and same hierarchy. It works perfectly. So I think this is a bug

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi ngadiez,

The visual only show the values in field. For example, there are Tokyo,Shanghai,Kyoto,Beijing,Osaka,Suzhou in the second level city, if you click the drill down button. For your requirment, you need to click the third button(highlighted in yellow background ), you will get expected result shown in third screenshot.



 





If you have other issues, don't hesitate to let me know.

Best Regards,
Angelia

ngadiez's avatar
ngadiez
Helper II
9 years ago

Hi Angelia,

 

Thank you so much for your reply.

However, I don't want the result shown in the third screenshot.

If we click the 'Expand all down one level in the hierarchy' I will get the third screenshot. That one I aware.

However now, when I right-click the bar and select drill down on the second screenshot. I get this third screenshot where I don't want. 

ie. When I right click and drill down China I get China Beijing, China Shanghai, etc. This one should happen when I click the third button from the left.

 

What I want when I drill down China, is to get Beijing, Shanghai, etc only.

 

Thank you so much.

 

I believe there is a bug.

 

 

Edit: when I retry new chart with same data and same hierarchy. It works perfectly. So I think this is a bug

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi ngadiez,

    Glad to hear that it works fine. Our product will become better because of your support and feedback

    Thanks,
    Angelia

    • PradeepKonda1's avatar
      PradeepKonda1
      New Member
      9 years ago

      v-huizhn-msft - Please read the post again. User has mentioned that Visual is NOT working as expected there is still a BUG