Forum Discussion
Order in a Column
Hi again ljimenezvega84
When you input the sequence number you have used a Text data type instead of number data type.
Therefore 101, 10 and 11 will sort before 2 !
If you change the data type to whole number, then it will sort numerically.This suggests you are a novice.
I recommend you do some Power BI learning before asking anymore basic questions,because you find these kind of simple answers and lots more within a minutes of learning.
You learn better via this structured laerning path, rather than lots pf questions.
https://learn.microsoft.com/en-gb/training/modules/get-started-with-power-bi/
Please click the [thumbs up] and [accept solution].
Learn more here
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-columnhttps://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
speedramps's solution is correct and i also used this on my report once. When you create a sort table you would need to mannually enter the serial numbers (positions) to the items you wanted to sort. This can be done by using 'Enter data' either on Power BI or Power Query, and it's suppsed to keep you away from those Number errors.
Thanks