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 data.
Measure I have written to achieve this :-
A (Yellow line) = HOUR(max(A[StartTime]))+MINUTE(MAX(A[StartTime])/60+SECOND(MAX(A[StartTime])))
B (Pink line) =
HOUR(MAX(B[EndTime]))+(MINUTE(MAX(B[EndTime]))/60+SECOND(MAX(B[EndTime])))
Format “Dynamic” This option I have enabled to making the Y axis in time.
And the measure I have written to achieve the format in “hh:mm”ss” the same I have written for start and end time. Please find below screenshot for the reference.
""""&FORMAT(max(B[EndTime]),"hh:mm:ss")
Not able to understand how its possible to getting the same Y axis scale and if difference in line in values for the particular date it should show the time accordingly.
5 Replies
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/1447523Hi 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.
lbendlin, Would it be possible for you to provide the code of this visual? How did you write a code to show time and date.
{ "data": {"name": "dataset"}, "encoding": { "x": { "field": "Date", "type": "temporal" } }, "layer": [ { "mark": {"type": "line"}, "encoding": { "y": { "field": "End Time", "type": "temporal" } } }, { "mark": {"type": "line"}, "encoding": { "y": { "field": "Start Time", "type": "temporal" } } } ] }
