Multi-line Column Labels in New Pivot Table Object

jmcy2408 — Tue, 28 Oct 2025 16:16:45 GMT

Hi,

I’m using the new Pivot Table object to display data and have customised the styling under Chart > Grid > Column Height (in lines) — setting it to two lines so that my column labels can appear on multiple lines.

However, even when I manually break the labels into two lines in the expression (or use CHR(10)), the text still wraps automatically in the visualisation instead of respecting my line breaks.

Is there any workaround for this behaviour?

The main reason I’m using the Pivot Table is to be able to lock scrolling on several dimensions — something that the new Straight Table doesn’t currently support, not even for a single dimension.

Thanks,
John

Re: Multi-line Column Labels in New Pivot Table Object

HirisH_V7 — Wed, 29 Oct 2025 18:57:52 GMT

Check this.

1 . =If(Len([YourField]) > 15, Left([YourField], 15) & Chr(10) & Mid([YourField], 16), [YourField] ) 2. =If(Len([YourField]) > 20, Replace([YourField], ' ', Chr(10)) [YourField] )

topic Multi-line Column Labels in New Pivot Table Object in App Development

Multi-line Column Labels in New Pivot Table Object

Re: Multi-line Column Labels in New Pivot Table Object