Color expression for different measures in bar chart

[dmitroika]

Hi guys,

I have a bar chart with 2 different measures. I would like measure1 to stay as a single color, while the measure2 should change color based on 3 set of values. 

I created master items for measures 1 & 2 and set color segment for measure2.

However, it doesn't work.

Here are the conditions that i need for measure2:

if measure2 < 0, red, if measure2 >0 and <=4, blue, if measure2 >4, green.

However, Measure1  must be yellow for all values

Thanks for your anticipated assistance.

Note: in the attachment file, measure1 is in yellow (correct) but measure2 is in red(wrong)

[lfetensini]

Use ValueList() ghost dimension trick.

[DIMENSIONS]:

1 Dimension: Your Dimension

2 Dimension:
= ValueList('measure1','measure2')
Label: Rename with your label

[MEASURES]:

Pick(Match(ValueList('measure1','measure2')),
'measure1',
'measure2'),
Sum(field), // Formula for Measure 1
Sum(field)) // Formula for Measure 2

[APPEARANCE COLORS]:

Check box: "The expression is a color code".

Pick(Match(ValueList('measure1','measure2')),
'measure1',
'measure2'),
Blue(),
Pick(Match(-1,
FORMULAMEASURE2 < 0,
FORMULAMEASURE2 > 0 and FORMULAMEASURE2 <=4,
FORMULAMEASURE2 > 4),
Red(),
Blue(),
Green())