Forum Discussion
Y axis having the same time scale
Hello, need some help, I have created a measure and format of the Y axis in “Time” But seems the Y axis showing the same time. Both the lines having the same time for particular date in...
Hi lbendlin, Unable to upload PBIX file here.
Please find sample data to create simple line chart.
Start TimeEnd TimeDate
| 9:13:37 | 9:13:37 | 9/17/2023 |
| 12:12:30 | 12:12:30 | 9/18/2023 |
| 15:25:40 | 15:25:40 | 9/19/2023 |
| 20:11:01 | 20:12:01 | 9/20/2023 |
| 01:05:03 | 01:10:50 | 9/21/2023 |
Mesure needs to be build.
End (Time) = HOUR(MAX('Table'[End Time])+MINUTE(MAX('Table'[End Time])+SECOND(MAX('Table'[End Time]))))
Start (Time) = HOUR(MAX('Table'[Start Time])+SECOND(MAX('Table'[Start Time])+SECOND(MAX('Table'[Start Time]))))
Line chart should have Y axis in proper format. Find Cunnret format of the line chart.
I used code to wrrite format in Y axis for Start and End time.
""""&FORMAT(MAX('Table'[Start Time]),"hh:mm:ss") &""""
Hope this sample data and code works for your. Looking forward from your response.
lbendlin
Super User
Super UserWith the standard line chart visual the best you can do is convert the time into a duration. Then the cart looks like
To have a true time Y axis you will likely need to use custom visuals like Deneb.