Forum Discussion
Solved
Different conditional formatting depending on date
Hi Awesome people I am wondering if it is possible to have different values for conditional formatting depending on date? I have a report showing SLA of incoming calls. Until February 2020 th...
Hi VegarOyfoss ,
Modify your measure as below：
Color = if(SELECTEDVALUE('Calendar'[MonthYear]) <="February 2020" && AVERAGEX('calls',Calls[ASA])<0.8 ,"red",if(SELECTEDVALUE('Calendar'[MonthYear])>="March 2020","lightgreen","yellow"))Best Regards,
KellyDid I answer your question? Mark my post as a solution!
amitchandak
I am trying to icorporate this to my model. The ASA is calculated with a meassure as below:
ASA = DIVIDE(Calls[SUM <20],Calls[SUM Accepts],1) and is modelled as %
In my Calendar table I have a column for MonthYear modelled as MMMM/YYYY i might be able to use
But I am not fully understanding the whole of you DAX. what does the 2014 in ('Date'[Year],2014) relate to for you?
Color = if(FIRSTNONBLANK('Calendar'[MonthYear]) <="February 2020" && AVERAGEX('calls',Calls[ASA])<0.8
,"red","yellow",if(FIRSTNONBLANK('Calendar'[MonthYear])>="March 2020","lightgreen"))
BUt this gives me an error stating Too few arguments passed to the first NONOBLANK function, which I suspect is the 2014 in your example.
Hi VegarOyfoss ,
Modify your measure as below：
Color = if(SELECTEDVALUE('Calendar'[MonthYear]) <="February 2020" && AVERAGEX('calls',Calls[ASA])<0.8
,"red",if(SELECTEDVALUE('Calendar'[MonthYear])>="March 2020","lightgreen","yellow"))
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!