Forum Discussion
Sort by another column error
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.
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
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.
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.
could you pls provide the pbix file?
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.
