5 Replies Latest reply on Apr 7, 2016 9:03 AM by Eleanor Jarvis

    Reverse Axis Based on Measure

    Eleanor Jarvis

      Hi,

       

      I have a problem that I don't believe has been answered elsewhere, and was hoping that someone could help me.

       

      I have a line chart that shows performance of different colleges over an eight year period. I have a dimension called measure that allows users to select the indicator that they want to view in the chart. This is currently used as a quick filter, and is working fine.

       

      However, for two of the measures (one is rank, the other is the number of members of staff per student), lower values are more positive than high values. I would like to be able to reverse the axis for these two measures. Maybe this can be done by using a calculated dimension, or maybe there is some functionality of the chart that allows this?

       

      Any advice would be much appreciated.

       

      Best regards,

       

      Eleanor