Sort column on matrix - not allowing descending sort on column

[po]

Hi,

Have the following issue.

We have a large matrix with % measure with value for each week column and plant name in the rows.

When look to try and sort in descending week order the availabel columns to sort on don't show week.

Also even when go to modelling and explitctly put sort descedning on the week column when put week in a visual like matrxi it is sorting in ascending order.

We wish to sort in descedning order as when users try and send the power bi doc to pdf or powerpoint to print they don't see all the weeks as these are scrollabel due to sheer amount of data.

Please see screenshots below.

week below going horizontally.

Any thoughts on how best to resolve to show weeks in most recent order horizontally?

Thanks

[Anonymous · Accepted solution]

A true feature to sort horizontally is missing, but there is a valid workaround - a bit spartan though.. 

1. Create a new calculated column where you switch your rows to an alphabetic or numeric sorted equivalent. 

Order = SWITCH(Table1[Week], 52, 1, 51, 2, 50, 3.. etc)

2. Follow this: 

Sort by column 

[po]

Thanks for suggestion.

Tried this and realised had to sort the week column by the other column rather than place a direct sort on the column and now looks to work as expected.

I would have hoped explitly going into modelling to sort the week in descending order for the column directly would have meant anytime column was used in a visual would display it in descending week order but doesn't.