Continuous x axis with missing data does not work on my Line Chart

[michaela_95]

I have a data with missing values. I want to display the points with the missing values but I want PowerBi Chart to ignore those and just keep drawing the line. 

This is where I am now: 

But I need to get to something like this without calculating some averadge value for 2019/20. 

 I thought of changing the x axis to categorical type but I don't have this option with my current data values. Is there anything I can do to get this sorted?

[michaela_95]

Is there now way to to keep text (categorical) values on the x axis? 

[lbendlin]

depends on what text you want.  Check this article: Creating a simpler and chart-friendly Date table in Power BI - SQLBI

Or use a custom visual.

[lbendlin]

Can't reproduce your issue when using numerical x axis values.

Can reproduce when using text.

That means your "continuous" axis isn't, it's already categorical.

Solution would be to drop the second year part and make the year numerical.