Forum Discussion

ED2005's avatar
ED2005
Frequent Visitor
3 years ago
Solved

Conditional Formatting for Dates on Matrix

Hi All I was wondering if you could help As per requirements I have a Matrix with Dates in PowerBI Desktop, and I would like the most recent date to be highlighted in different colour, but I ...
Need Help
Show and Tell
Tips and Tricks
  • Bmejia's avatar
    Bmejia
    3 years ago


    Create a measure or column value, then apply to your conditional format
    Example this measure if the date you have is greater then today then it be 1 else 0.

    Conditional Filter = IF(SELECTEDVALUE('Date'[Date])>TODAY(),1,0)

     

     

     



     

Bmejia's avatar
Bmejia
Super User
3 years ago


Create a measure or column value, then apply to your conditional format
Example this measure if the date you have is greater then today then it be 1 else 0.

Conditional Filter = IF(SELECTEDVALUE('Date'[Date])>TODAY(),1,0)

 

 

 



 

ED2005's avatar
ED2005
Frequent Visitor
3 years ago

Thank you!