Spaces trimmed

[zivhimmel]

Hi, 

I have a field where I intentially (in the database) have spaces to the left. It's a segment code with dots, and I'm padding spaces to the left to create a sense of indentation. However, when displaying the field in a table, Power BI automatically trimms those spaces to the left. How can I avoid this behaviour?

Here's what it looks like on the report:

10.1

10.1.2

10.1.3

But this is how the field actually is:

10.1

    10.1.2

    10.1.3

Thanks!

[ChrisMendoza]

@zivhimmel -

Does this work for you?

Column =
IF (
    LEN ( 'Table'[Column1] ) <= 4,
    'Table'[Column1],
    LEFT ( "     ", 5 ) & 'Table'[Column1]
)

[zivhimmel]

Thanks @ChrisMendoza , I don't think it will help.

I've applied the logic in my ubnderlying SQL server view, basically counting how many dots I have in the string

and adding twice as many spaces to the left of the string. I just need Power BI desktop to "respect" these spaces.

[zivhimmel · Accepted solution]

OK, I found what caused it.

'Word wrap' was on. I don't know why it causes this behaviour but turning it off, solves the problem.

Thanks!

[PhilAdams72]

Thank you!