Forum Discussion
Sorting error - can't be more than one value
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.
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.
It didnt work for me. I have unique items from an Excel sheet. In two PowerBI Report I am using this Excel sheet. In one PowerBI report the Sorting is working and the other one gives me an error. Also if I add an Index and sort it based on the Index.