Forum Discussion

IvanS's avatar
IvanS
Helper V
2 years ago
Solved

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

  • IvanS's avatar
    IvanS
    2 years ago

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

4 Replies

  • HotChilli's avatar
    HotChilli
    Community 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?

    • IvanS's avatar
      IvanS
      Helper V

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

      • jcesguerra's avatar
        jcesguerra
        New 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