Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kadapavel
Helper II
Helper II

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

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.

Capture.PNG

 

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

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@kadapavel,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
sherifff
Helper III
Helper III

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 - 

DateRegion ARegion B
01/08/20 1.71
01/09/201.891.88
01/09/20 1.99
01/19/201.49 
01/23/201.351.32
02/03/20 0.89
02/04/200.87 
02/12/201.301.38
02/16/20 5.59
02/21/201.60 
03/02/201.305.59
03/11/201.35 
03/12/20 7.83
03/24/201.776.19
03/27/20  
04/01/201.903.87

sherifff_2-1643486675462.png

 

 

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
Community Support
Community Support

@kadapavel,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.