Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Can I Make a Line in a Line Chart Disappear?

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!

 

 

  • 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.

     

4 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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's avatar
        amitchandak
        Icon for Super User rankSuper User

        Anonymous, instead of 0 make it blank after today's day. That should make it disappear.