Forum Discussion
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 to show green if it is after 11pm (for the times in the centre column). Up to now all I have is a late flag measure to show 1 if the time is before 11pm, my plan was to then format the late flag measure based on the value.
You can see from the below screen shot what I have done up to now, any suggestions would be greatly appreciated.
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
3 Replies
PhilipTreacy - Genius, worked a treat 🙂
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 - in fact now I look at it its putting everything as red, which makes me think its something to do with how the time is formatted maybe????
