on 02 Jun 2016 18:44:50
When my X-axis values are dates, it automatically format it to Day, Date, Month, Year which is very long and makes it unreadable. Allow formatting of dates in X-axis.
- Comments (1)
RE: Format date on Visuals X-Axis
An earlier idea has been marked as completed, but this is not so. As of the time of this writing, there is no facility to accomplish this where Dates display on the x-axis of a plot with the ordinal relationships preserved.
AuditDate2 = FORMAT([AuditDate], "DD-MMM") will transform the date data to text and sorting will proceed alphanumerically instead of preserving ordinal relationships between dates. Year relationships are also lost. We need a solution which formats and suppresses information not needed for the visualisation but still preserves it in the backround:
"01-Jun" in 2020 must not sort ascending as if before "01-Mar" in 2020
"01-Jun" in 2020 must not sort ascending as if after "01-Jul" in 2021