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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ghdunn
Helper III
Helper III

Sort by Column (again)

I am sorry...this will appear a FAQ, but I clearly am missing something very simple about 'sort by column'

 

If i enter a simple table

 

SortOrder  Category

a                 aa

b                 cc

c                 bb

 

 

If i then add a very simple table visual:

 

Category

aa

bb

cc

 

It is obviously sorting by ascending Category.  If I then select the field 'Sort Order' and go to Modelling\Sort by Column and tick SortOrder....wouldn't I expect to see:

 

Category

aa

cc

bb

 

?

But I don't...it doesn't sort by the column I have selected.  Plainly I am missing somthing super obvious.  

 

Gerald

 

1 ACCEPTED SOLUTION

Notice that I have Cat selected and then I picked the other column 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Nathaniel_C
Super User
Super User

Hi @ghdunn ,

So based on your ex, go to modeling and click on sort by, and click the column [Sort Order]  to get the order in the visual below.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

sort by2.PNGsort by.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Notice that I have Cat selected and then I picked the other column 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors