Forum Discussion
Linear
Hello!
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])
)
3 Replies
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])
)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.
HI Spurgeon74,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
