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



      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