Line Chart with DateTime X-Axis

[sabeensp]

Hello

I have a line chart with Date and Time on teh X-Axis, on Y-Axis I have Values. On one particular day I could have multiple Values.

Date_Time ------------------ Values

1/20/20 5:46 PM                    20

1/20/20 7:15 PM                    25

1/20/20 10:50 PM                  15

1/21/20  11:46 PM                 20

Data get's plotted just fine, but the distance between each of those date and time always spread equally, I would like to see distance between Date and Time distrubuted based on the time difference between dates and time.

[Abdel_20]

I have similar data to yours but I dont know how to plot the line to show th values over time without having to sum or count them? can you help please; you see when I tried to put the values of CO2 in the Y-axis it automatically applies the aggregation function count. PS I have already changed the settings to don't summarise and no calculation 

[v-gizhi-msft · Accepted solution]

Hi,

Please try to change your visual's X axis type to 'Continuous':

And it shows the different distance between each two date time:

Hope this helps.

Best Regards,

Giotto Zhi