Sort a matrix by a column when using a dataset

[Australan80]

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.

[mlsx4]

Hi @Australan80 

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://community.fabric.microsoft.com/t5/Desktop/Sort-Month-Year-in-Power-BI-reports-when-using-Azu...

https://community.fabric.microsoft.com/t5/Desktop/How-can-i-sort-months-in-Power-BI-when-get-data-fr...

https://forum.enterprisedna.co/t/sort-by-month-in-year-when-using-direct-query-mode/5828/8

[Australan80]

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?