Forum Discussion
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 below, i would like to sort rows by values in the column Road in desc order.
is it possible?
thank you,
Andriy
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
4 Replies
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
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 connectionoh 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
