Visualizing the difference between two values with color and area in a chart

[dagfiseha]

Hi Community

I am trying to create a visual in Power BI that shows the difference between two values (red for negative, green for positive), as shown in the screenshot below. Could any one support? 

Thank you in advance for your support

[dagfiseha]

Hi @Pragati11 

Thank you for your reply, the data looks as below.

[Pragati11]

HI @dagfiseha ,

May be next time please copy paste data rather tahn an image of the data. I had to type data in Power BI which takes a lot of time.

Are you looking for something like this:

Also I don't understand your chart as mentione din your question above.

[dagfiseha]

Thank you @Pragati11 for your reply and trying to help. Apologies for how I stated the question without data. I am new here, so I am not used to state question. I will think of it next time. What I am trying it visualize the planed amounts in comparision to the actual produced amounts, and the gab should complete the actual value. I am trying to get all the 3 values (planed, actual & gab) in the same chartt. and may be there  is another way to visualize it better than the above chartt I shared. 

Thank you again for your support, appreciate it much

[Pragati11 · Accepted solution]

Hi @dagfiseha ,

You can definitely compare all three metrics in the same chart, but the only question will be do you need a RED/GREEN conditional formatting on the Gab value?

May be you can get something like this:

See if this helps.

[dagfiseha]

Thank you @Pragati11 . I will try this and see if it's understable to the user. I gues, I can visualize it that way in Power BI

Thank you again

[Pragati11]

HI @dagfiseha ,

Is it possible to share some sample data that can enable us to create a solution?

Just the above screenshot doesn't help.