Forum Discussion
Conditionally Format Area Chart
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.
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.
14 Replies
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.This is what I want to achieve.
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.
Hi,
Share the download link of your PBI file.
Sorry but cannot help you with this.
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.
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.but this is not a solution to my problem. the final graph is not an accurate representation of my original graph.
