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
phillgrey
New Member

Is there a way to completely separate a column into a new query?

i want to make an custom sort order for an excel file. But the excel file has multiple columns which I want to order. So I want to apply the custom sort order on multiple columns but they are all attached.. Is this possible? Or should all the columns which I want to custom sort be separated from each other. Hope this is understandable

This is my custom sort

unknown (2).png

unknown (3).png

As you can see, multiple columns have these values. But in the visualisation I want to sort them by my custom sort.

 

Can I just merge the 2 and select all the columns? Followed by adjusting the sort order of each column to the custom sort?

 

i think the problem is that these columns are all connected to each other, making it impossible to custom sort them all separate, but I could be wrong.

1 ACCEPTED SOLUTION
ray_ux
Memorable Member
Memorable Member

@phillgrey 

right click -> drill down as new query. For sorting, in the power query editor the order you click sort is the order they are sorted by, like SQL If it does not work, it's possible you're getting syntax error by powerquery and need to double check the formula again. There are other ways to to sort e.g., you can set sort order in the model, but there might be more.

View solution in original post

1 REPLY 1
ray_ux
Memorable Member
Memorable Member

@phillgrey 

right click -> drill down as new query. For sorting, in the power query editor the order you click sort is the order they are sorted by, like SQL If it does not work, it's possible you're getting syntax error by powerquery and need to double check the formula again. There are other ways to to sort e.g., you can set sort order in the model, but there might be more.

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.