Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Icon for Continued Contributor rankContinued 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 in Power BI? Any help or guidance would be greatly appreciated!


Thank you in advance.

 

  • 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

     

     

1 Reply

  • 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