Sorting out sub-row values in the matrix.

[vcb_001]

Hi everyone,

I've got a question which could be quite straightforward to handle but, I haven't found any way to solve what I would like to reflect in my matrix table. Basically, please see the below attached screenshot where I need to sort values from 6 to 1 (descending) instead of 1 to 6 (ascending).

Is there any way of conducting a solution for this issue in the Power BI?

Thanks a lot for your feedback in advance.

[lbendlin · Accepted solution]

Use the "Sort a column by another column" approach.  Create a column in Power Query* that has the opposite values.  Then sort your original column by that column.

* If you try to do that in DAX you may get a circular reference error.