How to keep 2 X axis labels on separate lines and filter on Y value

[Anonymous]

Hi all,

I want to keep the 2 labels on the X axis in the screenshot separate, while sorting on a Y value. When I sort for Y, some of the labels concatenate onto the same line despite having Concatenate Labels turned off (second screenshot).

For example "Rapid" and "Tamara Hall" should be on different lines (as in the first screenshot), but the chart sorted by the Completed Apps value. 

I'd like to have the data sorted like this, but have "James Curl" and "ET" on seperate lines as the above screenshot. 

Any advice is appreciated. TIA

[v-yanjiang-msft]

Hi @Anonymous ,

In my understanding, you have two columns in the Axis of the stacked column chart, and you desire the name of the two two column display in two seperate line. By my test, it depends on the length and size of the name, the easiest way is to increase the text size of the X axis.

Best Regards,
Community Support Team _ kalyj

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

[amitchandak]

@Anonymous , Assuming You have two columns in axis, Use concatenate label - off and then sort again on Axis

[Anonymous]

Thank you for the response. Your suggestion is what I did in screenshot 1 that shows the labels correctly on 2 lines. However, when I then sort on a Y value (such as screenshot 2) it reverts back to concatenating the labels. 

I need the labels to be stacked like screenshot 1, but the columns to be sorted on descending values like in screenshot 2. Is that possible?