topic Re: create area chart with green and red colors to indicate profit and loss in DAX Commands and Tips

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

lawada4 — Thu, 15 Dec 2022 13:38:38 GMT

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

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

Anonymous — Fri, 16 Dec 2022 07:29:57 GMT

Hi lawada4 ,

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

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

Anonymous — Fri, 06 Sep 2024 15:29:56 GMT

Could you solve this?