Insert to Double Label of X axis

[Anonymous]

Hi all, 

I'd realize this : 

https://www.extendoffice.com/documents/excel/2715-excel-chart-group-axis-labels.html

in Power BI Desktop ?
Is it possible ? 

Thank all. 

[Anonymous · Accepted solution]

Hi there!

Yep- super easy. Two steps:

• Go to formatting in your chart, X axis formatting, and turn off 'concatenate labels'.
• Sort your data by your X axis

Here's a detailed post about it: https://www.wiseowl.co.uk/blog/s2516/hierarchy-label-concatenation.htm

Hope it helps!

Eva

[Anonymous · Accepted solution]

Hi there!

Yep- super easy. Two steps:

• Go to formatting in your chart, X axis formatting, and turn off 'concatenate labels'.
• Sort your data by your X axis

Here's a detailed post about it: https://www.wiseowl.co.uk/blog/s2516/hierarchy-label-concatenation.htm

Hope it helps!

Eva

[Anonymous]

Hi Eva, 

Thank you so much for your help ! 

I've done all steps and I managed to get double orizontal axis, but I can't get verticals bars vertical for subdiding every group. 

In other word, I can't visualize verticals bar in the graphic.
What can I do to solve this fact ? 

Thanks in advance. 

[Icey · Accepted solution]

Hi @Anonymous ,

Do you keep this on? 

Or you could try to sort again.

Best Regards,
Icey

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

[Anonymous]

Yes, I do. 
I've solved. 
My problem is due to blank colour in Gridlines. It's a banal thing, but not expected. 

Thanks !