topic Re: Change the sort order of data in a column in DAX Commands and Tips

Change the sort order of data in a column

Morgana_2022 — Fri, 02 Dec 2022 11:45:05 GMT

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!

Re: Change the sort order of data in a column

DimaMD — Fri, 02 Dec 2022 12:50:46 GMT

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

Re: Change the sort order of data in a column

Anonymous — Mon, 05 Dec 2022 03:23:04 GMT

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