Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Can you post a .qvw document that demonstrates the problem?
OK, I'll try and knock up a sample I can upload.
Check the 'Header Height' in the 'Multiline Settings' in the presentation tab.
Please see attached
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.
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.
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
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.