Line Chart Axis

[VijayAnaparthi]

I have a Date column on x-axis and numeric column on Y-axis. Also my Date column is in Date data type only but Date column has only date for 1st day of the month let's say the values are 01-01-2023, 01-02-2023, 01-03-2023 like that. So when i am presenting on Line chart its showing multiple days of the month on x-axis, even though my column has only 1st day of the every month.

I am using Auto for Axes in Line chart. Can we show values on x-axis according to our column values. Which is 1st day of the month.

Thanks,

Vijay 

[caltang · Accepted solution]

If you're talking about the Interactive Chart, it will read the dates as months. 

You can either:

A. Change the dates into Strings, and use that as the X-Axis, your values will remain as Dates instead of months.

B. Use the timescale button function under Axis:

Lets you view datetime as continuous rather than discrete.

[VijayAnaparthi]

Thanks for the replay. Actually above points are not required for my requirement. But i got the solution, it's a mistake from my end.  I am modifying on same layer that i created earlier. Later i realised that we need to delete the existing layer and needs to be create new layer if you want to modify anything in existing layer it won't change.

[caltang]

Glad you solved it!