Forum Discussion
Solved
Custom Sorting in measures (legend)
I'm unable to sort the data which comes from calculate measure as per below order,,any idea which steps needs to follow to correct the order Excellent 1 Good 2 Average 3
Create a static reference table in your data model. Keep it disconnected.
Feed the visual from the first column, Use the measure to find the selected value and return the associated result.
like this?
like below..Thanks lbendlin
| emp id | Score | Ref Id | Month | Cat |
| 44 | 95 | 1100 | Mar | Excellent |
| 44 | 75 | 1101 | Mar | Good |
| 55 | 85 | 1102 | Mar | Excellent |
| 55 | 100 | 1103 | Mar | Excellent |
| 66 | 45 | 1104 | Mar | Average |
| 66 | 85 | 1105 | Mar | Excellent |
| 77 | 100 | 1106 | Mar | Excellent |
| 77 | 95 | 1107 | April | Excellent |
| 77 | 50 | 1108 | April | Average |
| 88 | 45 | 1109 | April | Average |
| 88 | 50 | 1110 | April | Average |
| 88 | 65 | 1111 | April | Average |
| 99 | 100 | 1112 | April | Excellent |
| 99 | 50 | 1113 | April | Average |
| 99 | 35 | 1114 | April | Average |
| 100 | 80 | 1115 | April | Good |
| 100 | 80 | 1116 | April | Good |