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 will see the first level data and second level data.

Why do I see this?

 

For example First level country, second level city.

when i drill down usually i will see like 'Tokyo', 'Beijing', 'Amsterdam'.

 

However,  now I will see something like: 'Japan Tokyo', 'China Beijing', 'China Shanghai' etc

 

 

  • 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

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    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

      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

        Hi ngadiez,

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

        Thanks,
        Angelia