sort matrix rows by values in particular column

[AndriyK]

Hello,

i've a matrix with a category value on columns.

i would like to be able to sort rows by values in particular column, currently i can sort only by Total column

for example on the screenshot below, i would like to sort rows by values in the column Road in desc order.

is it possible?

thank you,

Andriy 

[vanessafvg]

you should just be able to click on the road field on the column name and sort

if you aren't able to, which seems odd then click on these 3 dots and you should have the option to sort

[AndriyK]

thanks for replying!
when i click on "..." i get options to sort by top field placed on the rows, or by measure used in the matrix which sorts by total amount (the last column)

when i press on column header, the column is selected/highlighted but not sorted

sorry, forgot to mention, the model is in SSAS tabular and PBI report connected with live connection

[vanessafvg · Accepted solution]

oh right i got it!  unfortunately no, you cannot sort that way. as the value is on the column.    if you move your column field to your rows you should be able to sort by them 

[AndriyK]

ok, thanks for replying!

i need these categories on columns 

i will try to look into couple of workarounds and see if it works for users.