Drill Down Problem

[ngadiez]

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

[v-huizhn-msft]

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 · Accepted solution]

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]

Hi @ngadiez,

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

Thanks,
Angelia

[PradeepKonda1]

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