Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Keep spaces in column fields when using table/matrix

Hi,

 

I'm struggling to create my own indentation in a table visualisation.

I have a 'Description' Column with all my P&L Lines and an Indent column with numbers. I created a new column using Text.repeat(" ",[Indent]) function so as to indent each line using the number in Indent column.

This works well and each line appears with spaces before the name in the DATA tab of PowerBI Desktop.

 

However, whenever I use the new column in a table or matrix, powerbi automatically remove all spaces before the name. Therefore the indentation is not visible.

 

How to keep spaces before the name of the field ?

 

EDIT

From the example of thebiccountant

 

What I want is the left tab but I always get the right one :

 

 

 

  • Hi Anonymous,

     

    Please turn off the "Word Wrap" option under Format pane.

     

    Best regards,

    Yuliana Gu

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Please turn off the "Word Wrap" option under Format pane.

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for your reply. It works well.

       

      I was also able to bypass this behaviour by inserting a different kind of spaces (full width) : [ ]

       

       

      Lichar

  • spryger's avatar
    spryger
    Frequent Visitor

    This only works for a Table, not a Matrix.

     

    For a Matrix, you need to go to Format > Row Headers > Text wrap

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you for this simple solution to this problem.  Saved me a lot of time.