Sort matrix by values in a column

[bo_afk]

Is it possible to sort a matrix by the values in a particular column from highest to lowest and vice-versa?

e.g. I want to see the highest values for column A, then see highest for column B etc.

I can see that we can do it in a table but I'm struggling to do using a matrix visual.

Any ideas?

Thanks

afk

[v-zhenbw-msft]

Hi @bo_afk ,

How about the result after you follow the suggestions mentioned in my original post?

Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@bo_afk , Not very clear. But you have the option under three .., for rows and values. If the column means to pivot. By default it will sort ascending or on the sort column and you can not switch that. Usually for descending sort we create a sort column like that and sort the column on that

example

date 1 = date

date 1 sort = rankx(all(Date), Date[Date],,desc )

Now we sort date 1 on date 1 sort and use that on mtarix header

[bo_afk]

Hi @amitchandak,

Suppose the matrix looks like the below. Market is my row value and category is my column and then I have a measure as the values. 

For example, I want to be able to sort category A by that measure so that AT is top of the list (14%), followed by HU and then DZ (7%).  

Is this possible?

[v-zhenbw-msft]

Hi @bo_afk ,

You need to click the three points of the matrix table in the upper right corner. Then sort by measure.

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.

[MattAllington]

I think you can do it using Q&A. Add the Q&A visual and ask for what you want and include "sort by x, then sort by Y". You will have to test it.