How to visualize 2 Time columns on Y axis and a Date column on X axis?

[PChmurzynski]

I have a table with 3 columns: Date, Time1, Time2. I need a chart where Y axis shows values from 0-23  and X axis shows dates in the range from the Date column. On that chart I want to plot two lines. 1 showing Time1, and 2 showing Time2 corresponding with the Date values. 

Date	Time1	Time2
01/01/2023	07:42:58	15:35:51
15/01/2023	07:20:50	16:00:56
25/01/2023	07:00:38	16:28:03
02/02/2023	06:42:23	16:50:13
15/02/2023	06:00:05	17:10:25
28/02/2023	05:41:43	17:31:40
07/03/2023	05:11:18	17:50:57
26/03/2023	06:30:50	19:10:17
01/04/2023	06:10:19	19:30:39
29/04/2023	05:39:44	20:00:03
11/05/2023	05:10:06	20:20:29

When I try to plot this Power BI aggegates the Time1 and Time2 fields to Count or Count (Distinct) and the show as flat, constant lines (purple and blue on the picture below). Power BI doesn't allow me to show the times without aggegation. I want to see those line like i drew them below orange and green. What am I doing wrong?

 

[miTutorials · Accepted solution]

Please check the below short tutorial on how to plot time on a line chart.

How to Plot Time on a Line Chart in Power BI | MiTutorials - YouTube

[PChmurzynski]

Thanks! that looks a lot better and If I add the time columns to tooltips I can see the actual times when hovering over. How do i hide the decimals times H.M and H.M2, so they don't show when hovering over?