Last post Oct 10, 2014 01:37 AM by Michelle Ge - MSFT
Oct 09, 2014 11:10 AM|nissan|LINK
Hello, I have a graph and my x-axis show date & time.
The start date is 1/28/2014 9:20:00 PM -08:00 and end date is 1/29/2014 4:35:00 AM -08:00.
In my Axis Options ->
Selected Axis Type as Scalar(Numbers/Dates)
I have set Minimum as =CDate(Format(CDate(Last(Fields!Time.Value, "dsEventGraphReportData")),"M/d/yy HH:mm")) // Should be 1/28/2014 9:20:00 PM -08:00
I have set Maximun as =CDate(Format(CDate(First(Fields!Time.Value, "dsEventGraphReportData")),"M/d/yy HH:mm")) // Should be 1/29/2014 4:35:00 AM -08:00.
Under Number -> Selected Date -> Custom -> M/d/yy HH:mm
But the graph shows dates starting from 1/29/14 5:15 - 1/29/14 12:30.
what am I doing wrong?
Oct 10, 2014 01:37 AM|Michelle Ge - MSFT|LINK
So far as I know, the x-axis has two modes. The mode is set by using the
Numeric or time-scale values option on the X Axis tab in the
Chart Properties dialog box.
So please refer to check the Category mode and Scalar mode, for more information about this, please refer to the link below:
The same time you need to check the Datetime type, please refer to the link below:
Hope it's useful for you.