How to change background color if the values are in increasing mode for 3 consecutive months

[svreddy4u]

Hi,

I have a data with state wise profit% across months and i want  to change background color if the values are in increasing mode for 3 consecutive months.

I am attaching the power BI file as well for better understanding.. Kindly help

https://1drv.ms/u/s!AhgwmjUaCW_4pSGUDu29J4KzV8JM?e=khFXu4 

[v-luwang-msft]

Hi @svreddy4u ，

The green background on your current file is, is your current existing Dax's not conforming to the results you want to get?

Best Regards

Lucien

[svreddy4u]

Hi ,

No, the current Dax is not conforming to the results i want to get..

I want to highlight in green color if there is growth for continuos 3 months and highlight in red color if there is degrowth for continuos 3 months.

Please Help