Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
3 years ago
Solved

Exclude future month&year on conditional formatting

Hi, hope everyone is having an awesome day. I would like to know how to exclude future months and years when applying conditional formatting to a matrix visual. Does anyone know how to do this ...
  • amitchandak's avatar
    3 years ago

    ronaldbalza2023 , Based on your measure,

    a new measure like this should

    if(max(Date[Date]) > eomonth(today(),0) , [Measure], blank()) 

     

    Do not color the blank value