Column color according to the target

[Michael92]

Hello all,

can you please help me with the following problem. It is possible to color in the column chart according to the target while every month is a different target?
Red if the value is lower than the target, Green if the value is higher.
I want to use Line and stacked column chart. While Line represents the target.

Thank you

Michael

[Arul · Accepted solution]

@Michael92 ,

I believe this is your expectation,

1. Create a measure by making necessary changes based on your tablename.

CF = 
IF(SUM('Table (2)'[Value])<SUM('Table (2)'[Target]),1,0)

2. Go to conditional formatting pane, click and open fx in the column option.

3. And select the Format style as rule and field as measure name and the choose the colors for the given condition.

Thanks,

Arul

[Michael92]

Perfect !!! It works. Thank you very much.