Forum Discussion

DevonVanDam's avatar
DevonVanDam
Helper I
6 years ago
Solved

Matrix value sorting multiple years

Hi,   I am trying to sort the attached values in a brand (first column) from high (top) to low (bottom). In the KES3_1 column I have subbrands, but I don't care about how they are sorted. So th...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi, DevonVanDam 

    To my knowledge, It couldn't achieve that Sort columns by value in matrix visual, you could only sort by total value or dim field in matrix

    here is the idea you could vote for it and make this feature coming sooner.

     

    Best Regards,

    Lin

parry2k's avatar
parry2k
Super User
6 years ago

DevonVanDam I afraid that you can do use more than one sort column in matrix, so once you sorted on brand or 2019, you cannot sort 2nd column.

 

Post an idea on ideas forum with this feature if there is one doesn't exist or vote existing idea.

DevonVanDam's avatar
DevonVanDam
Helper I
6 years ago

Is it possible to sort based on 2019 only then? 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi, DevonVanDam 

    To my knowledge, It couldn't achieve that Sort columns by value in matrix visual, you could only sort by total value or dim field in matrix

    here is the idea you could vote for it and make this feature coming sooner.

     

    Best Regards,

    Lin