Table sorted by column and keeps the spaces

[JohnDahis]

Good day.

Simple data below and I want PowerBi a Table display the same.

Name	Order
John	1
Kate	2
Lilly	3
David	4
Maggie	5
Ted	6
Will	7

Data view looks ok, and it's sorting by the Order column.

But Visual's not. (I only want the Name column in the table.)

The spaces in front of texts are removed, and the sorting seems not working.

How can I have a table shows the texts like above? Thank you.

[Anonymous · Accepted solution]

Hi,

To sort a column based on another one, use the "Sort by column" in the Modeling menu.

To keep the spaces, disable "Word Wrap" in the Values section of the table settings.

Best Regards // Ulf

[JohnDahis]

@amitchandak, thank you! actually I need to choose the Column "Name" to Sort by Column "Order", instead of doing it on "Order".

@UlfBergqvist, thank you for the solution

[amitchandak]

Have you tried

[amitchandak]

Refer:

https://community.powerbi.com/t5/Desktop/How-to-trim-space-from-Power-BI/td-p/194308