Unable to change data format on X axis

[Anonymous]

I am unable to change the date format of the x axis.  I have read some where that I have to change the type between continuous and categorical, but I don't have that option in the Format section.

I did not see a place to upload the file, but I am happy to share it if you tell me how.

[Anonymous · Accepted solution]

Hi,@Anonymous,I am glad to help you. @Ashish_Mathur ,Thank you very much for your help with this question!
I'd like to share my thoughts below.
Here are my test results:
When your X-axis is displayed in full calendar format (with year, month and day)

At this point you don't have this option when choosing Type for the X-axis (choose ‘Continuous’or ‘Categorical’)

solution1:
If you want to display the date column in its original format, you can select the drop-down box for the x-axis in the Filters area and choose to display it as the original column name (just click on the original name of the column), which  allows you to select 'Continuous' or ' Categorical'

solution2:
If you only show any of the time columns (in the calendar) in the x-axis, you can show and set the type of the x-axis (choose only one option :Year/Quarter/Month/Day).

Like this:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

What do you mean by "change the date format of the X-axis".  Upload the file to a file hosting service such as Google Drive and share the download link.  Show the problem very clearly and also the expected result.