Gap in the line chart data / gap in raw data connected to events which have 2 minutes interval

[kadapavel]

Hello

I have data from sensor with sampling frequency 1(s) there is also a controller which generates events based on environment condition.

The row data and events are shown in one page.

I have notice that:

if my event occured at 04:20:19 PM  then Line chart visual starts showing raw data from 04:20:00 PM, that is actually great as It is important to see some time before the event.

if event occured exactly 04:20:00 then I do not have this luxary

Does someone created nice way of selecting intervall before and after? But that is nice to have, I have another problem 

if in one larger EVENT I have subevents and gap between them mote then 1 minute.

For example 

event 01: at 01:18

event 02: at 01:19 (connection will be good between 01 and 02)

event 03: at 01:26 (in this case row data between 01:19 and 01:26 will have gap and edge point will have straight line.

Is there any way to have row data connected properly by extending/allowing longer "window", is there any setting which controls the window length, the 1 minute interval 

With best regards

Pavel

[sherifff]

Hi @v-chuncz-msft ,

I have similar issue i have 2 values in X series in a Line Chart.    I have gaps in the values in both the values. 

Region A - 
REgion B - 

Date	Region A	Region B
01/08/20		1.71
01/09/20	1.89	1.88
01/09/20		1.99
01/19/20	1.49
01/23/20	1.35	1.32
02/03/20		0.89
02/04/20	0.87
02/12/20	1.30	1.38
02/16/20		5.59
02/21/20	1.60
03/02/20	1.30	5.59
03/11/20	1.35
03/12/20		7.83
03/24/20	1.77	6.19
03/27/20
04/01/20	1.90	3.87

If you look at the data, both Region A and Region B doesn't have the values continously and in the Line Chart  the line just breaks whereever there is a GAP (No values) in the field. 
Could you please guide me what measure i need to write here, which it should dynamically connect the data lines and show full line in the line chart.

THanks in Advance! 

[v-chuncz-msft · Accepted solution]

@kadapavel,

You may create a time table and then add a measure.