Order in a Column

[ljimenezvega84]

Hi everyone, i have a very simple column with accounts name just like this:

There is a way to reorder the column manually? Not ascendent or descendent, just a manually reorder.

Thanks

Column Name

Net Revenue

Salaries

Expenses

Other Expenses

Other Salaries

[speedramps]

Thank you @ljimenezvega84 

Sort by column is a good trick.   You will use it lots now you know how !

[speedramps · Accepted solution]

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-column

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

[ljimenezvega84]

Hi speedram thanks for your solution

Regards

[v-aatheeque]

Hi @ljimenezvega84 ,

Just checking in to see if the solution provided by @speedramps  helped to resolve your query regarding manually reordering the account name column.
Could you please confirm if the issue is now resolved or if you need any further assistance?

If one of the recommendations helped, marking it as the Accepted Answer would be very helpful to other users.

Thank you for your contribution to the Microsoft Fabric Community!

Best regards,
Atheeq | Microsoft Support Team

[MasonMA]

Hi @ljimenezvega84 

@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

[speedramps]

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

[ljimenezvega84]

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