11 Replies Latest reply on Feb 20, 2020 12:55 AM by Simon Runc

    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