Sort in Matrix

[hill]

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.

[amitchandak]

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

[lkalawski · Accepted solution]

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

[hill]

Thanks and it works well!