Forum Discussion
Continuous x axis with missing data does not work on my Line Chart
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?
3 Replies
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.
Is there now way to to keep text (categorical) values on the x axis?
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.
