Forum Discussion

a-simarg's avatar
a-simarg
Icon for Helper II rankHelper II
7 years ago

how to sort inside a matrix ?

 

how can I sort from lowest to highest the Support Options Column?

The two columns marked with yellow is a single field - Page area- and contains those two Recommended solutions and Support options

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    a-simarg if you have used column you cannot sort, so one way to resolve is to create two measures for each option and then use those in matrix and then you will able to sort on it.

     

    For example:

     

    Base Measure  =<your calculation>,

Recommended Measure = CALCULATE(  [Base Measure], YourTable[Your Coloumn] = "Recommended" )


Support Measure = CALCULATE( [Base Measure], YourTable[Your Coloumn] = "Support" )

     

     

    • a-simarg's avatar
      a-simarg
      Icon for Helper II rankHelper II
      7 years ago

      i manage to get my case solved by using another visual from the Market place. see above.

      your solution it is not working for mycase because my column - Recommended Solution or Support Options are only some choices from a column and not individual Columns