Conditionally Format Area Chart

[bobbob123]

Hi,

I would like to condtionally format my area chart.  I have a profit, area and year column.

I would like format the chart so that if the profit value is below 0, then the chart is red. If it is above 0 then the chart is green.

I don't know how to attach the a PBI file, but I've attached an Image.

[v-henryk-mstf · Accepted solution]

Hi @bobbob123 ,

It seems a bit odd, but the best way to display it would be as follows.

M1 = IF([M_value]<0,[M_value],0)

M2 = IF([M_value]>0,[M_value],0)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bobbob123]

but this is not a solution to my problem. the final graph is not an accurate representation of my original graph.

[bobbob123]

Hi,

This is my data.My data in a table.

All i want to do is draw the area chart so that if it is below 0 then the colour is all red, if it above 0 then the colour is all green.

[v-henryk-mstf]

Hi @bobbob123 ,

The link you provided is temporarily inaccessible.

I want to say that something like AREA VISUAL does not support adding a similar judgment condition. I think you can try stacked column chart and create a measure as a conditional judgement. Refer to the following test results.

M = IF(MAX('Table'[Value])<0,"red","green")

not work in area visual

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bobbob123]

This is what I want to achieve. 

[v-henryk-mstf]

Hi @bobbob123 ,

I understand your needs. In my reply I already pointed out that something like AREA VISUAL does not support this kind of display. You can try to use a visual like stacked column chart instead.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bobbob123]

What about something like this video??

https://www.youtube.com/watch?v=-mAFHM1_bXc

[v-henryk-mstf]

Hi @bobbob123 ,

The video you provided requires you to create two separate measures instead of the value field. Is this approach acceptable to you?

Best Regards,
Henry

[bobbob123]

I'm happy with what ever solution. As long as it works 🙂 

[v-henryk-mstf]

Hi @bobbob123 ,

That's pretty good. You can follow the steps in the video to get the results you want.

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[bobbob123]

I coulnd't replicate the video 😞 

This is why I need help! 

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[bobbob123]

Here is the pbi file. 

[Ashish_Mathur]

Sorry but cannot help you with this.