Create nested if statements in color by expression

[Anonymous]

I created a positive-negative bar chart and I would like to implement 2 colors: green for positive values and red for negative values for example.

I have used two measures to obtain this chart a Min(value) and a Max(value), so when I insert a color expression I have something like this:

=If(Min(Value) < 0, Green(), Red()) but I would like to create a nested if statement something like:

=If(Min(Value) < 0, Green(), Red(),

     If(Max(Value) > 0, Green(), Red())

But I'm not sure if I can use this approach in this case cause is not working. Any ideas how to create something like this?Thanks,

[OmarBenSalem]

what's the expression you're using in your chart?

[felipedl]

Hi Sinziana,

Instead of using min(Value) and max(value) for the color, use your expression for the color option (selected in blue in my screenshot).

something like:

if(sum([Compras Preço Custo])>0,Green(),Red()) // sum([Compras Preço Custo]) is my expression for the graph below).

In my case, it gives me

Since your expression is if(min(Value)<0,Red(),Green()), its always evaluating true, because your min value for the dataset is lower than 0 (zero) giving all bars the red color.

[agigliotti]

why not using simple expression as below

=if( Sum(Value) < 0, Red(), Green() )

?

[Anonymous]

The thing is my chart is created with 2 columns of data united: a list of values that I want to see below the line (I gave them the minimum function) and a list of values that I want to display above the line (I gave them Maximum function).

That's why the syntax doesn't work in my case because I have 2 stacked measures and your syntax works with a measure (sum([Compras Preço Custo]) and 2 colors .

Maybe you have another idea how to display my data above and below the line O without the trick of Min and Max function. All values are on the same dimension.

[agigliotti]

why do you need two values for each year ?

[Anonymous]

There are two series of data (two values) united in the same graph because they show different things: a series shows how many processes ended in each year and the second how many processes started.

[agigliotti]

what about your color request related to those series of data ?

what's exactly the logic you have in mind ?

[Anonymous]

I want the values above in blue (Positive series of values) and the values below (Negative series of values) in red for example.

[agigliotti · Accepted solution]

I guess you can't because you have only one expression color to set for both measures.

To achieve what you want you should be able to set color expression for each measure.