Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Replace certain cells

I have a set of data that I want to sort, simply it has a list of questions 1 through 19, then a case question and a situational questions 

I tried the format as Text but the slicer goes Question 1,10,11 and so on then the text questions
I changed the column format to Numbers, it sorted the questions properly but returned the two text values (Error) as you can see
Is there a way to sort the data 1,2,.....19, case, situational

Tips and Tricks

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    plse try this

    Number.From( Text.Select([Column1],{"0".."9"}))

    then sort the column

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It sorted the numbered questions, but returned "Null" for case and situation as the column data type is numbers
    when I replace errors, I can only change one so it's either all shows as case or situation

    I'm trying to show this list in a slicer if that helps