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 ?

       

      thanks

      Michel