Forum Discussion
Yet another Sort by another Column error.
I had to refresh the data and then quit Power BI Desktop and reload it up again and then it allowed me. It must have been a caching issue.
No, but just creating a table to sort another table, that just seems unnecessary. perhaps in some instances it is not. The solution, ultimately, was to refresh the data, quit Power BI Desktop and load it back up again and it allowed me to sort. It must have been a caching issue from a previous attempt when I didn't have unique values.
Thanks for looking into it and even teaching something that I didn't know was a thing. I am pretty new at all this.
Restarting PBI worked for me too. I had created the Sort with the wrong FORMAT setting but when I changed it, I was still getting the error.
Exiting out of PBI and reloading resolved the error and am it is now sorting on the new column.