Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to write a colour expression which ignores my date filters but am having a lot of trouble getting it to work. This is the colour expression:
if(Year= '2021', 'Lightgray', if(Year= '2022', 'Green'))
I created a variable called vIgnoreDates which I want to add to this expression so that it ignores selections.
Can someone please help me on what expression I should use?
Thank you in advance
can you try like below...
if(only({<Date=,date2=>}Year)= '2021', 'Lightgray', if(only({<Date=,date2=>}Year)== '2022', 'Green'))