I have a dataset with with 2 columns title and measure
Example
Shift Measure
Day 1000
Evening 335
n/a 1234
Night 5678
Rotating 111
Variable 222
on my report I wrote a Switch Expression to change the label but how do I change to correct order?
=Switch(Fields!Position_Shift.Value like "n/a","4th Shift", False, Fields!Position_Shift.Value like "Day Job","1st Shift", Fields!Position_Shift.Value like "Evening Job", "2nd Shift", Fields!Position_Shift.Value like "Night Job", "3rd Shift", Fields!Position_Shift.Value like "Variable", "E/N Shift", Fields!Position_Shift.Value like "Rotating", "Rotating Shift" )
Result shows as
Shift Measure
1st Shift 1000
2nd Shift 335
4th Shift 1234
3rd Shift 5678
Rotating 111
E/N Shift 222