Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create a line break (long headings) for the column headings in a new pivot table (Visualization bundle)? I have already tried everything here.
@Bernhard_B Pivot Table does not provide a direct option to wrap text for column headers. However, you can achieve it using CSS if you have access to custom styling.
.qv-object-pivot-table .qv-st-header-cell {
white-space: normal ;
word-wrap: break-word ;
text-align: center;
}
increase the header row height using html/css or try vizlib if your company has its license and you can do line breaks in the text with chr(10) like below
= 'This is a long Header' & chr(10) & 'hence using a Line Break Using chr(10)' & chr(10) & 'And Another Line break for the display'
This can done to the field values too:
you can do line breaks on field values too wih same methods
if you want to give line breaks on an existing field name, try storing the field name in a variable and then do below:
try: = left('meas', 1) & chr(10) & mid('meas', 2, 1) & chr(10) & mid('meas', 3, 1) & chr(10) & right('meas', 1)