Forum Discussion
Line graph representing hours on Y-axis
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
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]))/1003. 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.
5 Replies
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
- lbendlin
Super User
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).
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]))/1003. 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.
DE acuerdo con la conversión, pero como muestro en las etiquetas de valores las horas originales?
