Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
marciofornarii
Frequent Visitor

keep white spaces before text

Hello!

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

marciofornarii_0-1702932262410.png

 

but into a matrix, not show this spaces:

marciofornarii_1-1702932424923.png

 

How can i fix it?

1 ACCEPTED SOLUTION
marciofornarii
Frequent Visitor

Solved! Solution:

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

marciofornarii_1-1702991309251.png

 



marciofornarii_0-1702991285581.png

 

View solution in original post

3 REPLIES 3
marciofornarii
Frequent Visitor

Solved! Solution:

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

marciofornarii_1-1702991309251.png

 



marciofornarii_0-1702991285581.png

 

v-xinruzhu-msft
Community Support
Community Support

Hi @marciofornarii 

Close the text wrap of the row header

vxinruzhumsft_0-1702954997261.png

 

Then it will display the space.

vxinruzhumsft_1-1702955020102.png

 

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.

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

marciofornarii_0-1702984809798.png


CSV File:

marciofornarii_1-1702984895066.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.