9 Replies Latest reply on Aug 23, 2017 4:52 AM by Leanne Vermeulen

    Set Axis Range Based On Calculated Field

    Leanne Vermeulen

      Hi,

       

      I'm working on a dashboard that utilizes multiple bullet graphs to represent different regions. As the bullet graphs are compared side-by-side and the max values across regions can vary somewhat, is there a way to fix the max value of each axis to the MAX(Measure)*1.5 or a similar calculated field?

       

      Obviously, the MAX value would have to be calculated across all regions, after any filters have been applied in the final dashboard.

       

      I see there's another post that's somewhat similar, but requires using an invisible reference line; but as my chart is a bullet chart, this is not a great option for me: Dynamic Axis Range - Fixing One End (or both, or have it dynamic)

       

      Any ideas?

       

      Thanks