Forum Discussion
Y axis having the same time scale
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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.With 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.