Drilldown Bar Chart without showing first Y-Axis level

[Marting86]

Hi,

I have a clustered bar chart for which I am using thr drilldown function.

For this purpose I have added two dimensions on the Y-Axis:

The drilldown generally works, when I click on a bar in the chart:

But for some reason the bar description on the second level displays the name of the first level in lead, then followed by the name of the second level. Here my example:

Click on OTHER EXTERNAL CU...

I want it to display only DENNREE GMBH as bar description, without leading first level name.

How can I fix this?

Thank you in advance.

Cheers

Martin

[v-yadongf-msft · Accepted solution]

Hi @Marting86 ,

This is my test table:

Create a clustered bar chart:

Click "Go to the next level in the hierarchy" option:

It will only display the name of the second level:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.