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
Yes that is easy to do
Create a table with name and sequence number eg 4,1,3,5,2
Then sort the name column by the squence number
Learn how here
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
Please click the thumbs up and accept solution button
Hi, thanks for your response. Yes i´ve try that, but unfortunatly when the number pass from 9 to 10, the table puts the 10 after the 1:
| 1 |
| 10 |
| 11 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |