Forum Discussion
Sort a matrix by a column when using a dataset
Hi all.
Apologies for the silly question as I assume there is a simple fix here.
How can I sort my matrix columns which show year then month is descending order rather than ascending?
I'm connected to a dataset so cannot edit the table data.
2 Replies
Hi Anonymous
I have never faced that case. But here there are some links. See if some of them helps:
https://stackoverflow.com/questions/60057652/sort-table-by-month-name
https://www.youtube.com/watch?v=n_gnuFS8qoY&feature=youtu.be
https://forum.enterprisedna.co/t/sort-by-month-in-year-when-using-direct-query-mode/5828/8
Hi mlsx4.
Unfortunately none of that helps.
Having come from using Tableau where sorting by columns in matrix view is a standard feature I find it amazing to think that in Power BI there is no easy way to sort by columns in matrix view.
Does anyone else have any ideas?
