Forum Discussion

marciofornarii's avatar
marciofornarii
Frequent Visitor
2 years ago
Solved

keep white spaces before text

Hello!

I have some specific rows with blank space before the text:

 

but into a matrix, not show this spaces:

 

How can i fix it?

  • Solved! Solution:

    Into Power Query: Substitute tab spaces to # or other character
    Into power bi: substitute the character # to tab 

     



     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi marciofornarii 

    Close the text wrap of the row header

     

    Then it will display the space.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • marciofornarii's avatar
      marciofornarii
      Frequent Visitor

      Hello, it's really work, but when my datasource is csv file, not work. I think thats a power query problem after apply the changes.

       

      Examples:
      Not Csv File


      CSV File:

       

  • Solved! Solution:

    Into Power Query: Substitute tab spaces to # or other character
    Into power bi: substitute the character # to tab