Sorting by a column error

[Elieekh17]

Hello Community,

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

Thank you,

[Anonymous]

Hi @Elieekh17 ,

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.

[Elieekh17]

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 · Accepted solution]

Hi @Elieekh17 

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.