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.
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...