Align first column width in pivot tables

chetan_cricut

Hi

I have a dashboard which has different width for the first column as shown for different cards. I would like to align the width in order to make the users read yearly numbers down in a symmetric order. Is there a way possible to align the width to same length ?

NateBI

Hi @chetan_cricut,
No, there is no "Set Column Widths" available with pivot tables to my understanding. A workaround would be to use the General / Allow Text to Wrap option, since this may have a default width configured.

DavidChurchman

You could go real old-school, use a monospaced font, and pad the column so they all have the same number of characters.

There might be an easier way to pad in a BeastMode, but something like this would work, where 25 is the maximum string length of a column value, and you pad it out with extra spaces ending with a period (or you could use underscores or whatever):

CONCAT(

your_column,

right('_____________________________.',

25 - length(your_column)

)

)

NateBI

Hi @chetan_cricut,
No, there is no "Set Column Widths" available with pivot tables to my understanding. A workaround would be to use the General / Allow Text to Wrap option, since this may have a default width configured.

DavidChurchman

You could go real old-school, use a monospaced font, and pad the column so they all have the same number of characters.

There might be an easier way to pad in a BeastMode, but something like this would work, where 25 is the maximum string length of a column value, and you pad it out with extra spaces ending with a period (or you could use underscores or whatever):

CONCAT(

your_column,

right('_____________________________.',

25 - length(your_column)

)

)