Forum Discussion
Sorting error - can't be more than one value
Hi,
i try to sort the Slicer from Modeling pane >sort by column >sort by YearFinMonthDay (which is the year the month and the day) so there cannot be a duplicate.
But its giving me this error 'there can't be more than one value in yearfinmonthday for the same value in workweek.
Can a kind person please assist ?"
cheers
It's a little tricky because we can't see the YearFinMonthDay values you have.
However, the error is caused because there are more than 1 value for YearFinMonthDay for one WorkWeek e.g. 29/ Mar/21 - 04/Apr/21 will have 5 values of YearFinMonthDay. Powerbi doesn't know which to use.
You need to find something to order by that has the same granularity as WorkWeek, something like Year and weeknum combined OR Year and 1st Day of workweek combined.
That's my theory.
6 Replies
Anonymous which column you are trying to sort? Does that is same as sort column?
For example,
you have 3 years dates in your calendar table and then you have month name column jan, feb march etc. so each month will repeat 3 times (1 for each year) and now sort column with 1, 2, 3, 4 (month number), so i this case you can sort month name with month number. Point here is that it doesn't need to be unique, but column you are sorting and column you are sorting by much have same value. hope I able to explain.
It's a little tricky because we can't see the YearFinMonthDay values you have.
However, the error is caused because there are more than 1 value for YearFinMonthDay for one WorkWeek e.g. 29/ Mar/21 - 04/Apr/21 will have 5 values of YearFinMonthDay. Powerbi doesn't know which to use.
You need to find something to order by that has the same granularity as WorkWeek, something like Year and weeknum combined OR Year and 1st Day of workweek combined.
That's my theory.
