Line chart, get value next to blank (measure)

[AnnaMagnusson]

Hi!

Is there a way to get values from one measure (that are the ones next to a blank) to another measure?

(I'm using categorical axis since I need to see the gaps). 

The grey dashed line (interpolated values) is not connected to the actual values because of my code. I want to somehow get the values next to the blanks so that I can connect the lines.

Is there a way?

Thanks in advance!

(Focus is one machine, yellow, and Comp is the comparison machines, grey)

[amitchandak · Accepted solution]

@AnnaMagnusson , you have to create a measure

if(isblank([Meausre]) ,[Measure1], [Measure] )