Forum Discussion
Conditionally Format Area Chart
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.
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 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