I'm seeing some very strange behaviour when trying to sort my series groups on a chart.
I have an Analysis Services dataset with Job Grades and Job Grade Codes, the job grade simply being a concatenation of the Job Grade and the word "GRADE", e.g.
1 | GRADE 1
2 | GRADE 2
3 | GRADE 3 etc.
I've pulled in the field Job_Grade into my Series groups section for a chart. I then tried to sort it by the key value which is the Job_Grade_Code like this:
This produced the following result:
I noticed that the sorting was incorrect. I noticed that in the source the Job_Grade_Code field was a varchar value, so I changed the sorting expression to the following:
This however made no difference and still sorted my grades in the incorrect order
View Complete Post