create area chart with green and red colors to indicate profit and loss

[lawada4]

I have created area chart that that shows profit and loss % over time. I would like to show the loss (negative part) in red color and the profit ( positive part) in geen color.

i created 2 measures one for profit % and one for loss % 

positive p&l =

var pl=[p&l %]

var result= IF(pl>0 , pl,0)

return result

negative p&l =

var pl=[p&l %]

var result= IF(pl<0 , pl,0)

return result

when i added the measures in the chart it looked  like:

any idea on how to create the area chart with green/red colors instead of 1 color

[v-jayw-msft]

Hi @lawada4 ,

Please share some sample data so that we could test the formula.