Q:

Order by a field which isn't included on a matrix POWERBI

I'm trying to build a matrix on PowerBI and I want to order the data by a field which I don't want to include in the matrix. My field named "category" in the matrix must be on a especific order, and I create a numeric field to specify the order. But when I want to order by that numeric field, I can't, PowerBI only allows me to order by the field which is in the matrix.
To test it, I concatenated my numeric field with the category like this: numeric - category, and it works, but I don't want to show it like that, I want only the category field order by the numeric field.
Any suggestion? Thanks.
EDIT:
I have also tried with "Sort by column", but neither selecting the matrix nor the data source table, the button is not activated.
Also detail that "category" has 2 or more numbers in "order" column.

A:

"Sort by column" was not activated because there were many duplicated rows in "Category" field, so I couldn't sort by "Order" because 2 or more rows share the same "category" with different "Orders". I fixed my database and now I can use the tool.

