SSRS Graph X-Axis number to month name
Posted on 2016-07-27
Hi all, I'm having a problem changing the X-Axis labels from a number to text; such as 1 to January, 2 to February, etc...
I've tried a number of things but the best I can get is that each number is change to text but it is the same text. So 1,2,3,4,5,6, etc.. are all showing January. I've create =Switch expressions and used the =MonthName(Fields!MONTH.Value, True) in the Format applet which shows all pints as "Jan".
I'm using SQL 2012.
Any help would be wonderful.