1 Reply Latest reply: Aug 25, 2016 7:00 AM by Bijoy B RSS

    Color by expression for two different measures in a Combo Chart

    Bijoy B

      Hi,

              I have a combo Chart, with two measures and one dimension.

                Property0101.JPG

              Currently I am using the multicolor option in my visualization, which is there by default (In Property -> Appearance -> Color and Legends).

       

                   Property02.JPG

           And by default my visualization looks as shown below .('Blue' for actual and 'Magenta' for Budget - as how legend showing)

       

                       Graph1.JPG

       

                                  I need to specify user-defined colors for each measure('Orange' for Actual and 'Blue' for Budget), similar as shown below.

       

                              Graph2.JPG

       

                 I have seen an option in Colors and legend, Custom color, By expression.

       

                 Please suggest me the expression to achieve my requirement.