Order by ascending / descending on a matrix view

[Anonymous]

Hi, I have a matrix filled with some data and on the total colmun I have the option to sort by ascending or descending order by clicking on the arrow like so:

Is there a way to apply that arrow to the other columns as well (like filtering using headers in excel) so I.e the column 2021/03 would be able to be sorted from the highest to the lowest value, that way I could see which one was the biggest value on march.

[lkalawski · Accepted solution]

Hi @Anonymous 

The only way to sort the column in the matrix is to create a measure for each date and add it as Values.
If you have column values in the Columns field - you cannot sort these columns.

[Anonymous]

Thank you

[rjhartop]

This blog post provides a different work around:

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

[Anonymous]

Nice workaround, some limitations , but good to know !