Diagramm two levels on the x-axis

[BaltoLo]

Hello,

I have a probebly pretty simple question but i couldn't find a solution.

I have the following two diagramms with their configuartions:

1:

2:

On the x-axis one tells me both Levels aka (Thema Aufgabe) the other only one (Aufgabe).
Can I somehow tell the other diagramm to also just use the last level for the x-axis?

Thanks in advance

[v-cazheng-msft · Accepted solution]

Hi @BaltoLo ,

If the contents of diagrams are completely fine, and you just remove the name of the first level ( Theme) from the x-axis of the bottom diagram. You can try the following steps.

In the case of selecting the visual “Leistungen im Vergleich je Thema”. You can rename X axis by input box in Axis title under Format section on Visualization Pane.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@BaltoLo , Not very clear. Can you explain.

You can use small multiples. Have only one value on X-axis. Move other to small multiples :https://youtu.be/a7PIApvjmVw

Other option is to expand (Reverse Square Y icon) - Then switch off concatenate label and sort correctly on-axis(using three dots.

[BaltoLo]

Both diagramms are Drill-Downs which use ase the first level the Attribute Thema on the x-axis and on the second level the attribute Aufgabe.
As you can see in the top diagramm in the blue box there is only the second level Aufgabe while in the bottom diagramm in the red box both are displayed. I just want to remove the name of the first level (Thema) form the x-axis of the bottom diagram. The contents of the diagramms are completly fine.

[parry2k]

@BaltoLo not fully clear about your question of what you are trying to achieve? A little more explanation will help.

[BaltoLo]

On the bar chart in the first image, only the word "Aufgabe",  the name of the second drill-down level, is used as the label for the x-axis, but in the second chart, both the names of the first level "Thema" and that of the second "Aufgabe" are used. I would like to remove the name of the first level under the second bar chart.