Forum Discussion
benqpbi
Helper I
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
Jayee
Responsive Resident
Responsive ResidentHi 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