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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
v4anand18
Advocate I
Advocate I

Sorting a table using multiple columns

Hi All,

 

 

Is it possible to sort a table using multiple columns?

 

 Revenue tableRevenue table

 

My table looks like this and i would like to sort by "Year" first and then by "Month". Is it possible?

1 ACCEPTED SOLUTION
StevePBennett
Advocate I
Advocate I

I see this tread is quite old, but sorting a visual by one column and then a second column is as simple as clicking the 1st column header to sort ascending or decending. Then simply hold the <Shift> key down and click on the header of the second column.
Of course you can just keep the <Shift> pressed and click on a 3rd, 4th etc until happy. 

I hope this helps. 
Steve B

View solution in original post

29 REPLIES 29

Hi,

I am trying to apply this step in my query editor as a step, but it throws an error. Could you please suggest how to resolve it.

Expression.Error: The name 'Changed Type' wasn't recognized.  Make sure it's spelled correctly.

 

Thank you,

Roopali

Hi @roopsnegi,

There is a break in your steps present in the Query Editor.

 

Check if all the steps are properly linked to each other. In simple words, there is a problem (mostly name related) with the steps before, in or after the Changed Type Step. 

 

If you post the M-Query of your query, it will be easy to solve this error....

The m code you’ve mentioned solve the problem to sort on the matrix visual? Would you post an example with repeated names? Cheers!
Thejeswar
Community Champion
Community Champion

@v4anand18,

Yes it is possible, but not from the visual side

 

You will have to do all the sorting based on multiple columns in the Power Query and then build you visual using the table.

 

If you have already built a visual, changing the sorting now might not show the proper sorting. In such case you will have to re-create the visual from scratch

 

Here's how the M code will look once you sort in Power Query

 

= Table.Sort(#"Changed Type",{{"Team", Order.Ascending}, {"Plan", Order.Descending}})

You can see from the below image that inspite of not applying sorting in the visual, due to the sorting at power Query, my data looks sorted as expected

 

i.e. In the Visual Team is sorted in Ascending Order and then Plan is getting sorted in descending order with in each Team.

 

sort.PNG

 

 

 

You can sort multiple columns in a table just by holding the shif key and clicking the column  headers you want to sort.

Hello,

I successfully edited M code in the query to sort how I would like, but after closing and applying the sort is not how I intended. I tried sorting the column by itself (default), but no success.

 

Suggestions?

 

Thank you,

Hi there,

 

This was helpful; however, when I exit out of power query and refresh the original data does not reflect the sorted values. Any thoughts on how to change that?

saf
Regular Visitor

Same problem... sorting ok in power query, but not in visual side...

You might need to sort by column but not into power query

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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