Forum Discussion
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...
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 May be try this, add actual and the sort column and the measure that counts the rows, and check if any of the rows has more than 1 value, it means that is duplicate. Sometime whitespace can lead to these issues which otherwise are not visible.
i'm sorry, i don't understand what you mean. could you explain again please?