?
Solved

SSRS Graph X-Axis number to month name

Posted on 2016-07-27
4
Medium Priority
?
50 Views
Last Modified: 2016-08-02
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.
0
Comment
Question by:Thunder724
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 41732336
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
0
 
LVL 4

Accepted Solution

by:
Thunder724 earned 0 total points
ID: 41733047
I figured it out in part.  I had to make sure the Category was set and that Axis range and intervals where set correctly; being Side Margins: Auto, Interval: 1, and interval type: Default.
That said I included a column in my stored procedure to be the textural name of the month too.

I am having difficulty figuring out one other graph in the same regards because the series is an expression not a column.
0
 
LVL 4

Author Comment

by:Thunder724
ID: 41733067
I got the last piece done the same as above; just had a query issue.
0
 
LVL 4

Author Closing Comment

by:Thunder724
ID: 41738726
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question