How can i get a continuous line between points if there is no data for a period?

[GRedhead]

Hi, i have a couple of charts where i have date for some months and not others, how can i join two points with a line when there is no data, for example the highlighted sections below, to create a continuous orange line?

the field behind the values is a mesaure, is there a way to add to this if the value is null take the previous months value? so that it will fill in the nulls?

Measure 2 Counts Opps = CALCULATE ( [Measure 1 Counts Opps] , DATESYTD ( 'FC Calendar'[Date] , "31/3" ) )

[amitchandak]

@GRedhead , Make sure FC Calendar is marked as date table, axis is using month from FC Calendar and join with fact table is single directional 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

[amitchandak]

@GRedhead , Make sure FC Calendar is marked as date table, axis is using month from FC Calendar and join with fact table is single directional 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...