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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JohnDahis
Helper III
Helper III

Table sorted by column and keeps the spaces

Good day.

 

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

 

NameOrder
John1
    Kate2
    Lilly3
    David4
Maggie5
    Ted6
Will7

 

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.

 

30.png

 

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

@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
Super User
Super User

Have you tried

 

Sort_by_column.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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