Axis label date format

David Goodrum shared this question 3 months ago
Answered

How do I change the date format on a chart axis? I created a chart with a time series horizontal axis with units of weeks. The date labels on the time axis are displaying in format "DD:MM:YY 12:00 AM". I want to change the date format so that the time does not display, and I can't find where to do it.

Comments (1)

photo
1

Hi David,

the way to change the date format on the chart axis is, within the Data screen of the Report Builder go to Column Formatting->Display->Format, there you will see that the default setting for a DateTime column is "Timestamp":

/tmyxMRjArJZmUxpCfSlPeedNWU9u17j2yDbkzqgJdXqONiopC0kSQshl5P8D2TirQpnRbvwAAAAASUVORK5CYII=

which displays the DateTime column as you've described, "DD:MM:YY 12:00 AM"

/w9PhpGsTCfrUgAAAABJRU5ErkJggg==

So what you've got to do is to change the Format value from "Timestamp" to "Date" as follows:

/w9SPCk+cCqZNAAAAABJRU5ErkJggg==

and then you'll find that on the chart you'll only see "DD:MM:YY":

/fQVtJZMSuQUAAAAASUVORK5CYII=

I hope that helps you meet your reporting requirements!

regards,

David