Forum Discussion
Sort by another column error
I am trying to sort by another column, and I'm getting the popular error, we can't sort the column X by Y. There can't be more than one value, yada, yada, yada. I created a numeric sort column u...
Hi Ryan,
Unfortunately, I can't share this data. However, I built the logic for the table, including the sort field, in SQL rather than PowerBI (DAX), and it's working as expected. Thanks for your responses.
I was getting the same error. And like you, my values had one to one relationship. I saw a mention elsewhere about using a conditional column. So I did that and it worked. In Power Query I added a conditional column, using your Type values and assigning the Sort value.
Thank you - I tried this as well and it didn't work.