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.
My table itself of course has lots of other columns and there are lots of Mondays and Tuesdays, etc. and the "DayNum" column is in the same table. So I don't have a small table at all. I guess I could add one but it seems overkill just to sort one column.
Small table with 9 rows is very far from overkilling. It will solve the issue , and this is how pbi's engine like to work 🤓
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.Happy to hear that the issue is solved.
You can accept your answer as solution.
According to small table and efficiency , note that the small table for sorting is only 18 cells.
When you adding to your table a column for sorting the number of cells is the same of the big table...
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.
