Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sorting in Matrix visual

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 ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

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