Forum Discussion

Anonymous's avatar
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 u...
General Comment
  • Anonymous's avatar
    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. 

Anonymous's avatar
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's avatar
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. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you - I tried this as well and it didn't work.