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



      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.