Is there way to hide 0 values on a line in th...

[Chris_Landsman]

Is there way to hide 0 values on a line in the Row Series [Line] graph?

For example - on the image posted the orange line has no data after the first point, but it’s interpreting the blank data for future months as a 0 value.

The graph compares one year of sales to another, and I’d like to have this year’s line (orange) fill is as the data is compiled.

I’ve tried different values and conditional formatting, but can’t get it to work.

[Bellave_Jayaram]

AFAIK, you cannot do what you are asking for currently

[Steven_Coile]

Use a slice to omit the zero-value rows, then graph that slice.

[arunkw]

How to do this? 

Please give an example of a custom expression to use to omit the zero-value for all the columns.