cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wfarrell19
Advocate I
Advocate I

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: 

 

Area chart.PNG

 

Thank you for your time.

 

- William

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

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")

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

3 REPLIES 3
v-frfei-msft
Community Support
Community Support

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")

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!