Forum Discussion
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 op...
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" )
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