Issue with sorting by another column

[IvanS]

Hi guys,

I am struggling to enable sorting or column Category by column Category_Order. I did such sorting numerous times before without any issue but this time I cannot proceed.

As you can see, each category have its unique Category_Order number. The column Category_Order is formatted as whole number.

What I am doing wrong this time?

Thank you for any help

IvanS

[HotChilli]

There's something a little odd about the Category_order column.  Numbers are right-justified in data view and they usually have a slightly different font applied.

Is this some strange setting I don't know about or has something gone wonky with the column/datatype?

[IvanS · Accepted solution]

Hi @HotChilli ,  the issue got resolved after closing and reopening Power BI Desktop file. 

[jcesguerra]

really? i vae the same issue and haven't been able to fix it. i had also done that sorting previously and now i get the same error message you did. but reopening the file doesn't fix it

[IvanS]

Hi @jcesguerra ,

can you paste anonymized data here for review?