Forum Discussion
How do I sort by a specfic columns in values in a matrix
Super UserHi Anonymous
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.
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.
- MFelix
Hi Anonymous ,
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.
Hi Anonymous ,
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