Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sorting by a column error

Hello Community,

 

Kindly help in the below error while sorting a text column with a number column:

 

Thank you,

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous 

    After testing, you don't need to sort it by the number, when you create the field paramater, the text number will order by the Parameter Order automatcially, so you don't need to order it, you can refer to my sample. 

    I create the following paramater.

    Then put it to the slicer, it will keep the paramater order.

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    1.If you  create the number column by the text column, it may cause some problem,can you provide the error picture that you have faced or the code that hide the private meassage.

    2.Please check that if you have some error in power query, it may also affect it.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      hello Anonymous , thank you for your reply, in fact I created fields parameters with number columns which starts from 0 till 39 ( 40 fields) but when I sort the parameters names by the order (the numeric column) I got the error shared above

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous 

        After testing, you don't need to sort it by the number, when you create the field paramater, the text number will order by the Parameter Order automatcially, so you don't need to order it, you can refer to my sample. 

        I create the following paramater.

        Then put it to the slicer, it will keep the paramater order.

        Best Regards!

        Yolo Zhu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.