Forum Discussion
Solved
Conditional formatting for time
I"m looking for a way to do a conditional format on the table below. I have users who log in each day of the week. If they log in after 8:05:00 AM I want that day to highlighted in a Red. Step 2 If...
ShawnPrice
Try follow the steps:1. In query editor, select the two columns and then unpivot:
2. Close apply, create a flag measure
flag = IF(SUM('Table'[Value])>TIMEVALUE("8:05:00"),1,0)3. Create a conditional format for Value column, rule by the flag measure
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ShawnPrice - Is your time an actual date/time or text? If it is actual date/time, then it is really a decimal number of 1/24/60/60 essentially and you could set you parameters accordingly.
The Data Type is Time, the Format is h:nn:ss AM/PM
ShawnPrice - OK, then your threshold should be .33680555555555556. That is 1/24/60 * (8 * 60 + 5)
