23 Replies Latest reply: Jun 15, 2016 3:29 PM by Sunny Talwar RSS

    Custom Colors By Measure In Bar Chart

    David Weiser

      I am trying to have each bar in the graph be represented by a different color.

      I am in Appearance, set Colors to "Custom" and "checked" The expression is a color code"

       

      I wrote the following expression:

       

      if(ValueList('Conclusive','Inconclusive', 'Partially Conclusive')='Conclusive'

           ,rgb(64,3,95)

           ,if(ValueList('Conclusive','Inconclusive', 'Partially Conclusive')='Inconclusive'

              ,rgb(0,0,192)

              ,rgb(192,250,60)

           )

      )

       

      It is defaulting all 3 bars to the last else color... rgb(192,250,60)

       

      Please advise...

       

      Thanks

      David