Forum Discussion

hill's avatar
hill
Helper I
5 years ago
Solved

Sort 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...
Need Help
  • lkalawski's avatar
    lkalawski
    5 years ago

    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! 😀

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    hill
    Helper I
    5 years ago

    thanks, though seems that your solution is for another problem!