Line graph representing hours on Y-axis

[Anonymous]

Hello 🙂

I have a data set that represents an end time of a process that runs everyday : 

20/05/2021 10:13

21/05/2021 10:14

22/05/2021 10:12

23/05/2021 10:12

etc.

I would like to represent the evolution of the end time throughout the month meaning I have to represent an date/hour type on the Y-axis. I have tried several things but it never works. 

Do you have any tips to represent this ?

Thanks, 

Caroline

[Anonymous]

Hello ! 

I am coming back on this topic to share with you an upgrade solution for this issue, maybe it can help somebody ! 

To represent an hour on a Y-Axis you can use @Anonymous solution where your time will be represented as a number by adding the minutes, divided by a hundred, to the hours. It means that 10:15 will be 10,15. But to have a more precise graph you can create a custom tooltip on which you will put your data in an hour format. So instead of displaying 10,15 it will display your time with the correct format.

Caroline

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created the data:

Here are the steps you can follow：

1. Create a calculated column.

Date value = LEFT([date],10)

2. Create measure.

Measure 2 =
HOUR(MAX('Table'[date]))+MINUTE(MAX('Table'[date]))/100

3. Open the line chart and place [date value] in axis and [meausre] in values

4. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Lau_Canaveri]

DE acuerdo con la conversión, pero como muestro en las etiquetas de valores las horas originales?

[Anonymous]

Thank you it worked perfectly ! 

[lbendlin]

Add transforms that separate out the date and time parts of your values - either using the built in functions or by doing integer/fraction math (dates are integers, times are fractions).