Change the sort order of data in a column

[Morgana_2022]

Hello everybody,
I have a powerBI table object, with a column populated by the following entries in alphabetical order:

• Certification
• Dictionaries
• Hed
• Primary
• Secondary
• Tutoring

Instead, I have to sort the entries according to this (non-alphabetical) order requested by my client:

• Secondary
• Primary
• Dictionaries
• Certification
• Tutoring
• Hed

How can I do?
Thanks to whoever will answer!

[Anonymous]

Hi  @Morgana_2022 ,

Here are the steps you can follow：

1. Power Query – Add Column – Column From Examples -- Custom rules.

2. Choose [Column] -- Column tools – Sort vy columhn – [Index] – Choose Sort ascending.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[DimaMD · Accepted solution]

Hi, @Morgana_2022 You can sort in the table as follows.
1 Create a table in Power bi, with serial numbers

2 Click on your column, select Column Tools and perform these actions

you also need to bind this table to the main table, as a result, your visualization should sort as you wish