Change line graph visual based on whether date is future dated

Hey Shawry ,

in addition to what vicky_ and fahadqadir3 , already mentioned, I create a measure for the future values that also starts with the month before the future starts, I do this to overcome the gap.
The Measure:

futureValues = 
var currentmonth = SELECTEDVALUE( 'DimDate'[MonthNumber] )
var lastPastMonth =
    CALCULATE(
        MAX( 'DimDate'[MonthNumber] )
        , ALLSELECTED( 'DimDate' )
        , ALL( 'DimDate'[past or future month] )
        , 'DimDate'[past or future month] = "past" 
    )
return
if( currentmonth >= lastPastMonth
    , CALCULATE(
        [SalesAmount (ms)]
        , ALL( 'DimDate' )
        , 'DimDate'[MonthNumber] = currentmonth
    )
    , BLANK()
)

Please be aware that the column future or past month from the calendar table has to reflect the use case. For this example it was simple, because I consider June the last "known" month, and July the first future month.

But this allows me to "transform" the top visual with the gap between June and July into a visual with a continuous line:

I tend to use a solid line because instead of a dotted line because sometimes there are past values I do not want to show as you can see from the table:

For this reason, I use a solid line that is visualized on top of the "past" values; if I used dotted lines, then the line would look a little awkward.

As @fahadqadir3 suggests, having two measures will solve the problem of rendering a dotted line on top of a solid line, but then you will have two measures that might increase the overall solution complexity.

Finally, you have to consider whether the monthly values represent values at the end of the month or at the beginning of the month. My example assumes a value at the end of the month. This consideration is relevant for the color of the line (the segment) between June and July

Hopefully, you will find this approach to avoid the gap useful.

Regards,

Tom