Sorting in the crosstab (column 1)

[DagdasAlbag]

Hello,

how do I get the sorting in column 1 (year 2021) descending in a crosstab?

The sorting refers to the total column, see Figure 2.

[DagdasAlbag]

Thank you for your answer!
Unfortunately, there is no solution to my question.

[AllisonKennedy]

Sorry, I forgot there's no 'tooltip' fields for matrix and tables so the workaround I use for other visuals sorting doesn't work here. I've added another reply that is long but will work. 🙂 

[AllisonKennedy]

@DagdasAlbag  You haven't provided a lot of detail, but if I understand correctly, you can add a measure or column to the tooltips and that will enable you to select it in the 'filters on this visual'. 

So add a measure for the value you want to sort by: 

2019 Measure = CALCULATE ( [Measure], DimDate[Date] = 2019) 

[DagdasAlbag]

Unfortunately it did not work

[AllisonKennedy · Accepted solution]

@DagdasAlbag  I meant like this, needing to create explicit measures for each year: 

[amitchandak]

@DagdasAlbag , if you are using a  column in matrix, you can only sort on the grand total of values or on row column