Plotting Time Values In A Graph

[SachinC]

Hi there,

I have sample data shown below in the grid.

The time values are by date - with upper and lower boundaries of 6pm and 8pm.

Times should sit between these boundaries.

Ideally I would like to plot a line graph, showing the upper and lower boundaries as lines, where my "actual time" is plotted between. Any values that cross the boundaries are breach of SLA.

Please help me make this work.

Thanks,

CollectedDate	CollectedTime	Lowerboundary	UpperBoundary
04/10/2017	18:47:23	18:00:00	20:00:00
30/07/2017	19:48:00	18:00:00	20:00:00
09/12/2017	19:59:48	18:00:00	20:00:00
09/01/2017	19:45:50	18:00:00	20:00:00
15/09/2017	19:29:43	18:00:00	20:00:00
08/07/2017	19:11:08	18:00:00	20:00:00
19/08/2017	18:12:58	18:00:00	20:00:00
24/11/2017	18:04:36	18:00:00	20:00:00
11/07/2017	18:20:01	18:00:00	20:00:00
17/12/2017	19:24:06	18:00:00	20:00:00
25/11/2017	19:21:30	18:00:00	20:00:00
05/03/2017	18:27:13	18:00:00	20:00:00
22/04/2017	19:39:13	18:00:00	20:00:00
30/11/2017	22:00:00	18:00:00	20:00:00
23/10/2017	18:48:58	18:00:00	20:00:00
23/10/2017	19:02:04	18:00:00	20:00:00

[parry2k]

basically you need to convert your hh:mm to decimal, i'm sure there are other way, let's start with this:

add following 3 columns 

Upper = VALUE(FORMAT('Time'[UpperBoundary], "hh.mm"))

Lower =  = VALUE(FORMAT('Time'[Lowerboundary], "hh.mm"))

Collected = VALUE(FORMAT('Time'[CollectedTime], "hh.mm"))

add line visual and drop collecteddate on x axis and 3 newly added column to values and change aggregation to max

[parry2k · Accepted solution]

you will get something like above