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

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

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....