Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

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 using a switch function based on the values in another column. I went into the table view, filtered the table by each sort value, and confirmed there is one sort value for one value I'm trying to sort. No luck. I even copied the original field (the same exact values) to a new field, tried sorting, and got the same error. How is that even possible?

Is there some known bug? Any help is appreciated.

Thank you,

General Comment

Anonymous
2 years ago
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.

6 Replies

ryan_mayu
Super User
2 years ago
could you pls provide some sample data?

if you want to sort the column X by Y, then there must be one to one relationship between these two columns.

if there is a one to many relationship between columns , then you can't do that
- Anonymous
  Not applicable
  2 years ago
  Hi Ryan,
  
  Thank you for the response. There is a one-to-one relationship with the fields. Attached is a screenshot of the two fields added to a table. As you can see, there isn't a one-to-may relationship between the fields.
  - a27279
    Regular Visitor
    2 years ago
    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.