Line and stacked column chart – displaying all months when using legend

Hello,

In my sample data model I have 2 tables. First table contains information about sales, the second table is a date table created using DAX. 

I’m currently facing an issue with my line and stacked column chart. I’m trying to display the monthly sales amount in columns and the running total in a line. For the first scenario the visual is working correctly and shows all the months of the year on the x-axis, even if there were no sales in a specific month:

The situation changes when I am adding a column legend, the months with no sales disappear:

I’m looking for a solution that allows me to include the column legend without losing the display of months with zero sales.

Below I am sending the sample sales table:

Here is the date table created using DAX:

Date = 
VAR MinYear = YEAR ( MIN ( 'Fruits sales'[Transaction date] ) )
VAR MaxYear = YEAR ( MAX ('Fruits sales'[Transaction date] ) )
RETURN
ADDCOLUMNS (
    FILTER (
        CALENDARAUTO( ),
        AND ( YEAR ( [Date] ) >= MinYear, 
              YEAR ( [Date] ) <= MaxYear )
    ),
    "Year", YEAR ( [Date] ),
    "Month Name", FORMAT ( [Date], "mmmm" ),
    "Month Number", MONTH ( [Date] ),
    "Quarter", FORMAT( [Date], "\QQ" )
)

Here is the relationship:

Here is the running total formula:

Running Total = 
CALCULATE (
    SUM('Fruits sales'[Fruits sold]),
    DATESYTD( 'Date'[Date] )
)

Any help or guidance would be greatly appreciated.