Forum Discussion

sabeensp's avatar
sabeensp
Helper IV
6 years ago
Solved

Line Chart with DateTime X-Axis

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.

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

2 Replies

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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