Line chart not connecting on running total for fiscal month

[mgradijan]

I have a line chart that has all monthly data points connected when I choose a single year to show, but when I select 2 years to show a comparison, the months where there were no sales is not connected.   screen shots of 2020 and 2019 & 2020 are below.  what am I missing? 

[mgradijan]

the line chart as expected.......

[mgradijan · Accepted solution]

I figured out that I had put an if blank statement in so that the future monthly sales would not show up as a flat line to the end of the year.  

I redid the quick measure to create running total for sales by fiscal month and put this field in the Value box and now the graph displays as expected.   All set here

[mgradijan]

I probably should have listed the formual for the running total calculations: 

INVOICED SALES running total in Fiscal Month = IF(ISBLANK(SUM('Invoice_Master'[INVOICED SALES])),BLANK(),

CALCULATE(

    SUM('Invoice_Master'[INVOICED SALES]),

    FILTER(

        CALCULATETABLE(

            SUMMARIZE(

                'Date Table',

                'Date Table'[Fiscal Month Number],

                'Date Table'[Fiscal Month]

            ),

            ALLSELECTED('Date Table')

        ),

        ISONORAFTER(

            'Date Table'[Fiscal Month Number], MAX('Date Table'[Fiscal Month Number]), DESC,

            'Date Table'[Fiscal Month], MAX('Date Table'[Fiscal Month]), DESC

        )

    )

))