5 Replies Latest reply on May 10, 2018 12:04 PM by Deepak Rai

    Hiding a specific bar in a bar chart that is after TODAY() without hiding the other bars after today

    Aileen Rotondo

      Hello,

       

      I am trying to find a way to hide the Sales bar that is in 2019. However, I don't want to hide the profit or shipping cost bar.

       

      I've tried creating a calculation called "Before today" which basically is..

      [Ship Date] < TODAY()

       

      So this shows me which data is after today, by showing true or false.

       

      I tried creating another calculation called hide (below) but I don't know where to put it.

      IF [Before today] = false THEN [Sales] = 0 END