Forum Discussion

benqpbi's avatar
benqpbi
Icon for Helper I rankHelper I
3 years ago
Solved

How 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
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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's avatar
benqpbi
Icon for Helper I rankHelper I
3 years ago

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's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

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.