Forum Discussion

Helper II

4 years ago

Solved

sort matrix rows by values in particular column

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 ...

Need Help

vanessafvg
4 years ago
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

vanessafvg

Community Champion

4 years ago

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

Helper II

4 years ago

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