Forum Discussion
Issue with sorting by another column
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
Hi HotChilli , the issue got resolved after closing and reopening Power BI Desktop file.
4 Replies
- HotChilliCommunity Champion
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?
- jcesguerraNew Member
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