Color Measures

[Anonymous]

My requirement is an equation for pivot table to change the color to red when the date is expired and green if it is valid

[Anonymous]

I can't open the file because still I don't have a license can you please copy & paste the expression here!

Best Regards

[Anonymous]

Something like

if(AddMonths(Max([Contract End Date]),-2)>Today(),Green(),if(AddMonths(Max([Contract End Date]),0)<Today(),Red(),Yellow())).

click on the '+' beside your expression in expressions tab

If you want background colours to be changed, put the expression in the background colour. Else in the text colour.

[mayuresh_d]

hi,

go to expression and click on + then u will find

background color for background

and text color for text

there u can insert condition like

if((expired/valid logic),red,green)

thanks and regards

Mayuresh