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.
AFAIK, you cannot do what you are asking for currently
Use a slice to omit the zero-value rows, then graph that slice.
How to do this?
Please give an example of a custom expression to use to omit the zero-value for all the columns.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |