Vertical Text in Pivot Table problem

[lawrenceiow]

How do I fix this problem I'm having when I select "Vertical Text on Column Labels" option in the "Presentation" tab of the pivot table Chart Properties. Each column is too wide for horizontal use so I changed to vertical text but now the heading row is ridiculously tall.

I tried changing the label to =' ' just in case it was the label that was causing the problem.

The hour time being displayed is coming from an inline table linked to the FactTable:

ActualTime,HourBand,HourBandTxt

00:00, 00:00, '00:00'

00:01, 00:00, '00:00'

00:02, 00:00, '00:00'

etc

23:59, 23:00, '23:00'

I added the third, "text" column in the vague hope that the issue was to do with date/time but this didn't work either.

[Gysbert_Wassenaar]

Can you post a .qvw document that demonstrates the problem?

[lawrenceiow]

OK, I'll try and knock up a sample I can upload.

[c_gilbert]

Check the 'Header Height' in the 'Multiline Settings' in the presentation tab.

[lawrenceiow]

Please see attached

[lawrenceiow]

Thanks for your reply Charlotte. This did not seem to make any difference. I tried to apply this whilst the text was vertical and it made no difference, I then tried to apply this whilst the text was horizontal and then made the text vertical afterwards - still not difference.

As requested by Gysbert I have uploaded a sample QVD file.

[Gysbert_Wassenaar · Accepted solution]

Set the label of the expression to a single space. That expression label is now empty so the length of the expression is used for the height of the header row.

[ashwanin]

Hi Lawrenceiow,

Follow the Gysbert's suggestion. It will solve your problem.

If you add any text in the label of expression ,It will automatically minimize the height.

Check your qvw here

[lawrenceiow]

Awesome!  Thanks Gysbert Wassenaar, so fast a response too. I'd tried changing the dimension label to a single space as this was quite long in my original QVD, never occurred to me that the expression label was the issue.

Thanks again.