Forum Discussion
Helper IHow to Sort in order correctly in visual
Why i am unable to sort in order of number 1 to 14, kindly help me on this.
thanks
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
9 Replies
ryan_mayuSuper User
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
benqpbii 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.
- Jihwan_Kim
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_seq17will 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....
- Jayee
Responsive Resident
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
