Linear

[Spurgeon74]

Hello!

I have a single measurement signal that sends readings at irregular intervals. How can I prevent Power BI from interpolating the data in the visual and connecting two points over extended periods, as shown in the attachment? Additional question: How do I display multiple irregular signals in an xy-chart without interpolation lines for missing values?

[v-saisrao-msft]

HI @Spurgeon74,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @Spurgeon74.,

Have you had a chance to review the solution we shared by @zenisekd? If the issue persists, feel free to reply so we can help further.

Thank you.

[zenisekd · Accepted solution]

Hi,

In Microsoft Power BI, a line chart always connects the available points unless you explicitly introduce blank values or segment the series.

One option  would be to use categorical, instead of continuous x-axis type.

Second option is to create a measure that breaks the line when the time gap is too large. The trick is returning BLANK() when the gap exceeds a threshold.

Value_NoInterpolation =
VAR CurrentTime = MAX(Data[Timestamp])
VAR PrevTime =
CALCULATE(
MAX(Data[Timestamp]),
FILTER(
ALL(Data),
Data[Timestamp] < CurrentTime
)
)

VAR GapMinutes =
DATEDIFF(PrevTime, CurrentTime, MINUTE)

RETURN
IF(
GapMinutes > 60, -- threshold you choose
BLANK(),
MAX(Data[Value])
)