Align first column width in pivot tables

chetan_cricut
chetan_cricut Member
in Charting

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 ?

image.png

Tagged:

Best Answers

  • NateBI
    NateBI Contributor
    edited January 21 Answer ✓

    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
    DavidChurchman Coach
    edited January 22 Answer ✓

    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)

    )

    )

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • NateBI
    NateBI Contributor
    edited January 21 Answer ✓

    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
    DavidChurchman Coach
    edited January 22 Answer ✓

    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)

    )

    )

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories