Omitting blank values in stacked line chart

I have a stacked line chart that is plotting month-over-month data for the purposes of visualizing how this month’s data stacks up against the same month last year and the year prior. Because the remaining months this year have no value, the graph is plotting a straight line for the blank months (in cumulative view) and a dip to zero (in non-cumulative view).

Is there a way for me to remove the graph points for months that have no data? I want my line to end at January (the month where the last current-year data is added to the table). I checked and unchecked the “show empty values” box, and that did nothing. See February - June.


Hey Kara,

I see what you’re referring to here. I am afraid at this time isn’t possible to remove those remaining graph points, without removing all. I recognise this certainly isn’t ideal and I’d be happy to raise this with our internal team to see if they can consider making the relevant changes in the future. Sorry for the setback Kara :pray:

Where do we stand on this, @BiancaT ? The line graphs are not really functional without the option to hide empty values. Thank you for prioritizing the implementation.

Best wishes,
Nico