Forum Discussion
Resolver IIDescending Order
I just got it to work. I had to pull from a new table, join the table, and then it worked... thanks for your help
At the moment Power BI doesn't have the capability to sort the column order of a matrix; only the row order may be sorted.
A simple work around is to add a custom column in data view that reverses all the values and sort by that column.
For example, if I'm currently using [MMM YYY] in my matrix and sorting it by serial month....
...then I would add a new column with the following formula.
This gives me a new column that I would then use for the 'Sort by column' option
Which makes my matrix go from this:
To this:
i820017I switched the sign of the YearMonth column, then I sorted by that new column, and it still didn't work. I am getting this.