Negative Values Colored Red in Area Chart

[wfarrell19]

Hello,

I am using a basic Area chart, and I would like to display the negative area in red. It seems like it should be easy, but I cannot find a way to do it. Please see below: 

Thank you for your time.

- William

[v-frfei-msft · Accepted solution]

Hi @wfarrell19 ,

We cannot achieve that using area chart directly. We can create a column chart to work around.

Here i create two measures.

Measure = SUM(Table1[log])

Measure 2 = IF([Measure]>0,"#a00d34","#3b9921")

Regards,

Frank

[v-frfei-msft]

Hi @wfarrell19 ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[Greg_Deckler]

Well, the only way that I can think of is if you have a table with those positive and negative values or create a summary table with the aggregation that yields you those positive or negative values. Then you could create a calculated column that uses that to return "Positive" or "Negative" and then use that calculated column in your Legend. But, even then it won't look right.