Calculated dimensions and Dimension limits

[googel84]

Hi there, I am trying to display bar chart x-axis labels spanned over 2 lines and to do so I followed what this reply suggests, i.e. using a calculated dimension that adds a carriage return somewhere in the middle of the field that you want to use as a dimension.

The trick seems to work in terms of labels but, actually, it seems like unexpected filters get applied as you can see by comparing the following two pictures.

The curious thing is that if I take the "Restrict which values are displayed using the first expression" flag off, I get close to the result I want to achieve:

Note the scrollbar that is now shown and that I don't want to display.

How can this be fiixed?

[googel84 · Accepted solution]

I found a very simple workaround: using (when it does not make any difference) the "Largest" criterion instead of "First" in the "Dimension limits" tab of the chart proterties.

I don't know why "First" was causing the problem but it was!