Line and stacked column chart suddenly blank when column series (legend for stacked) is added

[crln-blue]

Hello!

I found an unexpected behavior in PowerBI. 

For me, it is unexpected because I have the same report (just a different source, the report below has an excel file source but all of the calculations are also the same with the other report) as seen below:

So I recreated the report above and changed the source file to somewhere from SQL Server. All computations are the same, etc etc. The other reports are fine except that for this:

The line chart which has values are all gone. For context, all of my line chart has values. Column values, "Current Year Amount" has no values because of its filter date. This scenario is also similar with my report which has an excel source. 

If I remove the data from the Column Series field, the chart is okay:

As we all know, both the column series and the column values are the fields for the stacked column chart. So I have a measure for the values and for it to be a stacked column chart, we need to place a column under the column series field. But it seems like the Column Series data makes my chart blank. Why is this? Is there anything that I should set up? 

Thanks in advance!

[crln-blue · Accepted solution]

I'll close this thread now. I don't know why but it managed to solve on its own after dragging and dropping the Date values again.