Solved

SSRS Graph X-Axis number to month name

Posted on 2016-07-27
4
12 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
  • 3
4 Comments
 
LVL 26

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now