Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
Proud to be a Super User!
@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????
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
Proud to be a Super User!