Forum Discussion
Negative Values Colored Red in Area Chart
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
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
3 Replies
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
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
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.
