<div>
Try one of these:<br />
=Format(Fields!MONTH.Value<wbr />,&quot;MMMM&quot;)<br />
or <br />
=Switch(Fields!MONTH.Value<wbr /> = 1, &quot;January&quot;, <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fields!MONTH.Value = 2, &quot;February&quot;,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fields!MONTH.Value = 3, &quot;March&quot;................)<br />
this came from <a href="http://www.sql-datatools.com/2015/05/ssrs-how-to-convert-month-number-into.html" rel="ugc">http://www.sql-datatools.c<wbr />om/2015/05<wbr />/ssrs-how-<wbr />to-convert<wbr />-month-num<wbr />ber-into.h<wbr />tml</a>
</div>


Try one of these:
=Format(Fields!MONTH.Value,"MMMM")
or
=Switch(Fields!MONTH.Value = 1, "January",
                   Fields!MONTH.Value = 2, "February",
                   Fields!MONTH.Value = 3, "March"................)
this came from http://www.sql-datatools.com/2015/05/ssrs-how-to-convert-month-number-into.html [http://www.sql-datatools.com/2015/05/ssrs-how-to-convert-month-number-into.html]

<div>
I got the last piece done the same as above; just had a query issue.
</div>


I got the last piece done the same as above; just had a query issue.

<div>
I figured it out in a much different way presented. &nbsp;I also had tried the suggestion provided prior to asking this question and it did not work because the answer was not related to a graph; but an expression for non graph objects.
</div>


I figured it out in a much different way presented.  I also had tried the suggestion provided prior to asking this question and it did not work because the answer was not related to a graph; but an expression for non graph objects.

<div>
<div class="content wysiwyg-content">
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...<br />
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. &nbsp;So 1,2,3,4,5,6, etc.. are all showing January. &nbsp;I've create =Switch expressions and used the =MonthName(Fields!MONTH.Va<wbr />lue, True) in the Format applet which shows all pints as &quot;Jan&quot;.<br />
<br />
I'm using SQL 2012.<br />
Any help would be wonderful.<br />
Thanks,<br />
John.
</div>
</div>


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.
Thanks,
John.

SSRS Graph X-Axis number to month name

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.