Forum Discussion
Can I Make a Line in a Line Chart Disappear?
Hi!. I don't think you can solve something like that in formatting options. You can make a line invisible in formatting options. What you can do is change your data. You can create a measure of the red line with a condition that if it is this year it should return a BLANK value else the regular value.
Regards,
Anonymous, instead of 0 make it blank after today's day. That should make it disappear.
Super UserHi!. I don't think you can solve something like that in formatting options. You can make a line invisible in formatting options. What you can do is change your data. You can create a measure of the red line with a condition that if it is this year it should return a BLANK value else the regular value.
Regards,
Hi! Thank you for your reply!
I tried putting zeros into all the data fields after today's date. Then the line just drops. is there a way to just cut it off "mid air"?
- amitchandak
Anonymous, instead of 0 make it blank after today's day. That should make it disappear.
- ibarrau
Changing data should work too. I would recommend the measure to keep data and avoid it just for that chart.
I'm sorry, but as I have mentioned before I don't think there is a way to just cut it whenever you want with clicks or formatting options.
Regards,