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
amalrio
Helper V
Helper V

sorting a column with multiple vlaues

Hi all, 

 

I want to sort the SPLIT_COLUMN by year, when I do that it gives me an error saying cannot sort when you have miltiple values, 

 

any workaround to overcome this issue.

 

amalrio_0-1606098861390.png

 

 

amalrio_0-1606099365666.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@amalrio , Not clear final sort need. but try like

new columns

Split_column 1 =[Split_column]

Split_column sort = [Year] & " " & [Split_column]

 

Sort Split_column 1 on Split_column sort and use Split_column 1 

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@amalrio , Not clear final sort need. but try like

new columns

Split_column 1 =[Split_column]

Split_column sort = [Year] & " " & [Split_column]

 

Sort Split_column 1 on Split_column sort and use Split_column 1 

amitchandak
Super User
Super User

@amalrio , Sort column can not same value for to different values in the main column 

 

Say I have A and B two values in main column , sort column can not have 1 and 1 for both these .

Also If I have A and A on main column I can not have 1 and 2 for these two values .

So, what you would suggest to make this collumn sort as I required. Thanks a lot mate.

amitchandak
Super User
Super User

@amalrio , sort column need to have same granularity as the main colum.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Sorry, I do not understnd.

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.