I am new to SSRS and using with SSAS

See more:

SSRS-2008

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