Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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! Go to Solution.
Solved! Solution:
Into Power Query: Substitute tab spaces to # or other character
Into power bi: substitute the character # to tab
Solved! Solution:
Into Power Query: Substitute tab spaces to # or other character
Into power bi: substitute the character # to tab
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.
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:
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
60 | |
58 |