How to Sort in order correctly in visual

[benqpbi]

Why i am unable to sort in order of number 1 to 14, kindly help me on this.
thanks

[Jayee]

Hi @benqpbi 

Use column from example  transformation in power query and enter the number for each row what is the number you have after SEQ and power query will add all the rows and use the out put to sort by other columns.

https://learn.microsoft.com/en-us/power-query/column-from-example

Here the sample file

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[Jayee]

@benqpbi 

Did you check the sample file provided in the above reply

please check here the link again

[Jihwan_Kim · Accepted solution]

Hi,

One of ways to solve this is to create names like below.

Category

SEQ01

SEQ02

SEQ03

SEQ04

SEQ05

SEQ06

SEQ07

SEQ08

SEQ09

SEQ10

SEQ11

SEQ12

SEQ13

SEQ14

[benqpbi]

can i create a calculated column the full name looks like

abc_prog_gig_seq1
till
abc_prog_gig_seq17

will switch( true(), ) work ? 

thank you 🙂

[Jihwan_Kim]

Hi,

Creating calculated column might be not efficient.

Please try changing a name in the source.

Or,

Please try chaging a name in Power Query Editor.

Please be noted that try using 01 02 03 04 05 ....  not  1 2 3 4 5....

[benqpbi]

can you pls help me out here pls, if possible 🙂

How to add value in column which is not consistent - Microsoft Power BI Community

[ryan_mayu]

@benqpbi 

you can create a sort column and sort by the created column

pls see the offical article below

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

[benqpbi]

i did but my power query sorts correctly but in visual it is different and when i try to sort by creating index i get this error any ideas

[ryan_mayu]

that's because for the same task name, you have more than one myorder value. you have to make sure the relationship between these two columns is one to one.