Forum Discussion

dagfiseha's avatar
dagfiseha
New Member
3 years ago
Solved

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

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

 

Need Help
  • Pragati11's avatar
    Pragati11
    3 years ago

    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.

     

6 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    3 years ago

    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.

     

    • Pragati11's avatar
      Pragati11
      Super User
      3 years ago

      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's avatar
        dagfiseha
        New Member
        3 years ago

        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