Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional formatting based on date

Hello Everyone!   I am having some issues attempting to create a measure to conditionally format matrix columns based on date.    Here is what I am trying to do: In a Rolling 12 Month Sales visu...
Need Help
MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous ,

 

Believe this is related with the fact that you have blanks and not 0 try to add a +0 to your measure and check if it works properly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

MFelix Thanks for the reply! I am not sure what you mean though: where exactly in the measure do I add "+0"?

 

Thank you!

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Anonymous .

     

    Try to redo your measure

     

    Before Go-Live = IF(MIN('Calendar'[Date])<MAX('Sales'[Actual Go-Live]),0,1) + 0

     

    Be aware that not really sure if this will work, if you can share a sample file if it doesn't work would be helpfull to give you the correct answer.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      MFelix  Ah I see. I gave this a try and nothing changed. Unfortunately I do not have a sample file that I am able to share at this time but I will try to get something put together that is shareable. Thank you for your help!