Hi,
is there a way to change the format of the date axis?
I would like to instead of Sep 2020 use a format like 09-20. If I change it into a string and do it manually then it does not work correctly with the sorting.
Solved! Go to Solution.
Hi @Dennisklad1
How is the data coming in?
I think the easiest way is to transform the data in the exact format you want, as a string value before the interactive chart. Either transform the data or create a new column to use as reference.
If the data is a date format, it should show you this under the Axes tab.
Thanks for the reply.
Wouldnt that lead to sorting problems?
For example:
Sept-20 Oct-20 Nov-20 Dec-20 Jan-21
This in a string format would be sorted as:
01-21 09-20 10-20 ...
Hi @Dennisklad1
If the data comes in the correct order, it will not cause problems.
Order that comes in
Order that comes out