How do I sort by a specfic columns in values in a matrix

[GAPER]

for example if i want to sort the rows by the Asset Growth Column. How do I do that? Now only the total can be sorted. 

Thanks. 

[audreygerred]

Do you have a dimension in your columns and then one measure in your values? If so, that is why you can only sort by total. If you create an explicit measure for each item that is showing in your columns, then add each one into values with nothing in columns, you can sort by whichever measure you want.

[MFelix]

Hi @GAPER 

This depends on how you have your matrix setup if the values on the columns is a column value that you added so you have different "categories" you cannot due the sorting based on that value since that specific column is a characterist. I assume this is your case where you are using a column from a table in your matrix visualization.

However if each of the columns are individual values (measures) then you can do the sorting exactly how you do it in a normal table.

To solve you issue you would need to create a measure for each individual value.

[GAPER]

However if i make it as individual measures i lose the capability of having it to groupped together. And for model maintenance. I will need to be adding measures whenever there's new measuires coming in. 

[Anonymous]

Hi @GAPER ,

Maybe replace the value of the 'Total' column with the value of 'Asset Growth'? That would eliminate the need to create multiple measures.

Something like this

Best Regards

[MFelix]

Hi @GAPER ,

Not sure what you mean by keeping it grouped together, but the second part you are correct. This is the way the default matrix visual works, maybe you can check if a custom visual can have any of that option for you, but with the current one unfortunatly these are the two options.

[Joe_Barry]

Hi @GAPER 

Have you tried clicking on the column mame, this should sort it, from high to low, but it will only sort by tat column, if you want to sort on multiple columns, hold shift button and choose the columns you want to sort on

Joe