Forum Discussion
Line Graph Showing Progression Of Time Over A Date Range
Hi DamienJ,
In a chart visual, only numeric values are allowed to be added to Y-axis. If we drag non-numerical fields into Y-axis, it will be counted automatically.
To achieve your requirement, you should first convert Time format filed to numerical type.
Time in minute = MINUTE('Date/Time'[Time])
Then, create a line chart like below.
Best regards,
Yuliana Gu
Hi DamienJ,
In a chart visual, only numeric values are allowed to be added to Y-axis. If we drag non-numerical fields into Y-axis, it will be counted automatically.
To achieve your requirement, you should first convert Time format filed to numerical type.
Time in minute = MINUTE('Date/Time'[Time])
Then, create a line chart like below.
Best regards,
Yuliana Gu
Hi v-yulgu-msft and thanks for your reply. That approach had never crossed my mind - thanks very much! I did make a slight change to your suggestion as I needed the precision of seconds, and as the data is currently in Excel I used the following to convert the HH MM SS value to seconds:
=HOUR(A2)*3600 + MINUTE(A2)*60 + SECOND(A2)
(Other sites suggested multiplying the value by 86400 but this gave erroneous results in some cases)
Your screenshot suggests Power BI will be very happy with these new numbers. Thanks again!
