7 Replies Latest reply: Feb 10, 2017 12:29 AM by Carlos Reyes RSS

    Color by expression/measure

    Melissa Pluke

      Screen Shot 2017-02-09 at 12.21.16 PM.png

      Hi all.  I have read some of the other color by expression/measure posts, but still can't seem to figure this out, so I was hoping someone could help me.

      I have a bar graph that breaks down by Financial Division (and there are a few alternative dimensions as well).

      There are 5 measures I am using to get the stacked bars which sum a dollar amount:

      - $(vSum120)

      - $(vSum90)

      -$(vSum60)

      -$(vSum30)

      -$(vSum0).

       

      I am not able to add any additional dimensions to the graph.  I would like to be able to add custom colors to each of the measures and I can't figure out how to do so in the Color expressions field. 

      For the sake of the example, lets say these are the 5 colors I would like to use red(),lightgreen(),green(),lightblue(),blue().

       

      Any help would be appreciated. Thanks!