Forum Discussion

VegarOyfoss's avatar
VegarOyfoss
Helper II
6 years ago
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...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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
    Did I answer your question? Mark my post as a solution!
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi VegarOyfoss ，

 

Is your issue solved?If it is solved ,can you mark the reply as answered to close it?

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!