Forum Discussion

cath1ynn's avatar
cath1ynn
Resolver II
2 years ago

Sort by another column error

I've ran into this annoying Sort by another column error that I can't work out how to resolve because there are no duplicates!   I am trying to sort the month name (text) by the FinancialMonth fiel...
Need Help
cath1ynn's avatar
cath1ynn
Resolver II
2 years ago

You would not believe this but after refreshing the data in preparation to export it to CSV to build another PBIX file to upload, it seems to have fixed itself and now I am able to sort the Month field by the FinancialMonth field 🤔 I made no change to the data model and this wasn't even the first time that I have refreshed the data either. I was butting my head against the wall all of yesterday's afternoon with this error and now it just fixed itself 😠

 

 

BronSuchecki's avatar
BronSuchecki
Regular Visitor
1 year ago

Had the same problem, but my sort by column was a DAX lookupvalue. The lookup table had duplicates, I fixed that but then even with no duplicates it would not accept it. Fixed it by just deleting the column and re-entering it with exactly the same DAX code. It is like PowerBI will not clear the error status of the sort by column.