13 Replies Latest reply on Mar 2, 2017 12:23 AM by . Ashish

    Why does the axis shows negative values while the Measure doesn't ?

    Michel Caissie

      Hi all,


      I have a calculated field which sometimes return negative values. I want to filter the negatives so I adjusted the calculation to get rid of the 0.


      If [] - [] < 0 then 0 else [] -[] end.



      The problem is that if i bring this calculated field on the Rows shelf  along with a Dimension  , the axis still starts at a negative point.

      My goal is to force the axis to start at 0 . 


      I know i can fixed the start point of the Axis but it also force me to fix the end point, which i don't want to do because it will grow in time.


      Any clue on how to do this ?