6 Replies Latest reply on Jul 22, 2016 1:03 PM by Dan Armstrong

    Substitute string for measure in axis label (for certain values)?

    Dan Armstrong

      Hi,

       

      I have a bunch of bar charts with measures on the X axis and dimensions on the Y axis.

       

      I've been asked to label the X axis as follows:

       

      If the value is less than 1%, the label should say "<1%".

       

      If the value is 1% or more, the label should be the value.

       

      Tried doing this with a calculated field, but I can't mix numbers and strings.

       

      Is there a solution to this? Thanks.

       

      Dan