Is it possible to interrupt the line in a Line Chart when we have 0 values for Y-axis?
I want to get rid of the line , which is marked with X (see the screenshot).
Thanks for the answer!
I transformed the chart into a straight table and looks like the whole August is missing. However, I have all days values in some kind of calendar, so the Y-axis value appears to be not 0, but NULL.
I tried to put Expression value to : If(ISNULL([Expression]), 0 , [Expression]) to get the 0 value and use your expression,
but without success. Any ideas?
You should come up with this result:
In your case when the value is null the should be white().
Just use trail - error method and I am sure you'll get the right result. Or you could provide sample qvw file for community 🙂
we are one step closer to the end.
I succeeded to make the line where the value is null in ARGB(0,0,0,0),
but the legend color disappeared too if there are line interruptions.
I know I can make separate labels and put the below the chart, but is there any way to somehow make the legend with permanent colors and not affected by the expression background?
Thanks and regards,
The legend is shown in case there are more than one expression.
I would suggest creating one more expression but instead of line chart use Text as pop-up:
Did it help?