Sorting in Matrix visual

[Anonymous]

Hi Experts,

I am facing a scenario which is  Column to be sorted descending order in Matrix visual.

I used year field in column header with subheader 2019,2020,2021. I cannot see the sorting option based on values in each year.

       

If i sorted based on "Actual" column, only total actual values were sorted but i need individual column(like 2019/2020/2021) to be sorted upon clicking on it.

Is it possible to achieve like this?

Thanks.

[Anonymous]

hi @Anonymous , @amitchandak ... This solution does not suit to me. I'm facing the same issue but I want to stay dynamical and that the user can sort by himself. How can I do it? Any idea?

[v-easonf-msft · Accepted solution]

Hi,  @Anonymous 

The value of 2019 is part of the value in the original field. You can only sort the column as a whole.
As a workaround, please consider creating separate measures for the 2017, 2018, and 2019 , and apply these three measures to the value of the matrix.

2019 value = CALCULATE(YourMeasure,FILTER(Table,Table[Year]=2019))

2018 value = CALCULATE(YourMeasure,FILTER(Table,Table[Year]=2018))

2017 value = CALCULATE(YourMeasure,FILTER(Table,Table[Year]=2017))

...

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi @amitchandak ,

Thanks for your reply.

Here you mentioned about the sorting of column header but in my scenario, i want to sort the values in each column.

example: from the above snap, in 2019 column, the values should be sorted desceneding order like 256748, 67744, 37377 and 0.

[amitchandak]

@Anonymous , Create column in date table

Year 1= [Year]

Year sort =  rankx('Date', [Year],,desc,dense)

Mark Year sort as sort column of year 1 and use  year 1 in visual

Same case dicussed here

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c