Forum Discussion
Sorting out sub-row values in the matrix.
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.
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.
1 Reply
- lbendlin
Super User
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.