Forum Discussion
Helper ISort in Matrix
I have this matrix, and I find that I can only change the sorting of stock_name and Total by click them, as you can see the small triangle below.
But I also want to see the sorting of addition, new, reduction, soldall columns.
Is that achievable? and If so, how to do that?
Thanks in advance.
Hi hill
If in the Columns field (in matrix seeetings) you have added a field with the values "addition", "new", "reduction" and "soldall", unfortunately this columns cannot be sorted.
To enable sorting, you need to create a separate measure for each 'category' and then add it in the Values field (in the matrix settings).
_______________
If I helped, please accept the solution and give kudos! 😀
4 Replies
- lkalawski
Resident Rockstar
Hi hill
If in the Columns field (in matrix seeetings) you have added a field with the values "addition", "new", "reduction" and "soldall", unfortunately this columns cannot be sorted.
To enable sorting, you need to create a separate measure for each 'category' and then add it in the Values field (in the matrix settings).
_______________
If I helped, please accept the solution and give kudos! 😀
hillThanks and it works well!
- amitchandak
Super User
hill , Looking at the screenshot not very clear. But if you have used a column on the column group of the matrix . then it will sort ascending or sort on sort column. So create a sort column and mark it as the sort column for the column used.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Sort Column = Switch( true(),
[column] ="New",1,
[Column] ="addition" ,2,
//add other
)
Marj this as sort column. rest will happen automatically
Created month year sort in this video -https://youtu.be/Qt0TM-4H09U
- hill
thanks, though seems that your solution is for another problem!
