Forum Discussion

DannyAlfa's avatar
DannyAlfa
Frequent Visitor
2 years ago
Solved

Conditional Formatting Time

Hi all,   Hope you kind people can help with this, I have a table that I am trying to conditionally format based on time.   What I want it to do is show as red should the time be before 11pm and ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi DannyAlfa 

     

    Download PBIX file with the example below

     

    Create a measure

     

    Time Colour = IF( SELECTEDVALUE('Till Data'[Time]) < TIMEVALUE("23:00"), "red", "green")

     

    In the Conditional Formatting or the Time column use these settings

     

     

     

    To give this

     

     

     

    Regards

     

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

Hi DannyAlfa 

 

Download PBIX file with the example below

 

Create a measure

 

Time Colour = IF( SELECTEDVALUE('Till Data'[Time]) < TIMEVALUE("23:00"), "red", "green")

 

In the Conditional Formatting or the Time column use these settings

 

 

 

To give this

 

 

 

Regards

 

Phil