Can I Make a Line in a Line Chart Disappear?

[Anonymous]

Hello,

I have this Line Chart visual. I was asked to make the red one disappear after today's date. Is it possible?

thank you!

[ibarrau · Accepted solution]

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,

[ibarrau · Accepted solution]

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]

@ibarrau 

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 · Accepted solution]

@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,