Forum Discussion
Time values for conditional formatting, Kindly help me!
Hi team, Good Evening! I have the time values with "00:00" format in table visual(like below snapshot). I need to do conditional formatting like a) 00:00 to 01:59 with no background color, leave i...
HighlightTime =
VAR _time = SELECTEDVALUE(Gap[gap])
VAR _timeValue = TIMEVALUE(_time)
VAR _highlight =
IF(
_timeValue >= TIME(0,0,0) && _timeValue < TIME(2,0,0),
0, // no color
1 // red color
)
RETURN _highlight
You can create a simple measure, setting highlight to yes/no, then do conditional formatting:
HighlightTime =
var _time = SELECTEDVALUE('Table'[Column1])
var _highlight =
IF(
_time >= TIME(0,0,0) && _time < TIME(2,0,0) ,
0, // no color
1 // red color
)
return _highlight
Thanks for the response,
But currently my exiting time column is with text format.
While doing all the measures and all getting below snapshot error. Kindly please check and do needful pls.
Thanks in advance.