Forum Discussion

jcesguerra's avatar
jcesguerra
New Member
2 years ago
Solved

Error message when sorting by another column

Hi I used to be able to sort a column by an aorder set in another column with no problem But now I get this error message: "We can't sort the 'X' column by 'Y'. There can't be more than one value in...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    jcesguerra Sorry, let me try again:

     

    - add a table visual

    - add the column that you are trying to sort

    - add the column that you are using for sorting

    - add the following measure in the table visual

     

    Measure = DISTINCTCOUNT ( Table[SortByColumn] )

     

    click on the Measure heading in the visual to sort by measure, and see if there is any value which is greater than 1 and that where the problem lies.

     

parry2k's avatar
parry2k
Super User
2 years ago

jcesguerra Sorry, let me try again:

 

- add a table visual

- add the column that you are trying to sort

- add the column that you are using for sorting

- add the following measure in the table visual

 

Measure = DISTINCTCOUNT ( Table[SortByColumn] )

 

click on the Measure heading in the visual to sort by measure, and see if there is any value which is greater than 1 and that where the problem lies.

 

  • jcesguerra's avatar
    jcesguerra
    New Member
    2 years ago

    they all have a value of 1... including the blank. maybe that's the problem?
    (thanks a lot for your help!)