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.
new Sorting (2).pbix revised file attached..
i'm trying to get the out of 100% monthly for ref id data - the total doesn't match to 100%
Thanks in advance lbendlin
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