Forum Discussion

bobbob123's avatar
bobbob123
Icon for Helper III rankHelper III
4 years ago
Solved

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 ...
Need Help
Show and Tell
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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's avatar
bobbob123
Icon for Helper III rankHelper III
4 years ago

This is what I want to achieve. 

 

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

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.

    • v-henryk-mstf's avatar
      v-henryk-mstf
      Icon for Community Support rankCommunity Support
      4 years ago

      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's avatar
        bobbob123
        Icon for Helper III rankHelper III
        4 years ago

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