Sorting data

[medlalami]

Hi all,

I need to sort data by Week, but when I try to do it, I got the wrong result the data isn't sorted correctly:

Can we have another way to sort correctly this data?

[medlalami]

Problem solved by converting the column to numbers. Thanks for help.

[mahoneypat · Accepted solution]

Looks like your week column is sorting as text.  Convert the data type of your Week column to Whole Number and it should work correctly.

Pat

[amitchandak]

@medlalami , Seem like the data type is text, Change it to the whole number.

Or create whole number column with week number and mark as the sort column of this one

refer if needed

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