Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

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 it as it is.

b) 02:00 and remaining all values need to change with background color is red.

Kindly help me please!
Thanks in advance.

Data Protection

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

Anonymous
2 years ago
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

4 Replies

Y_S
Frequent Visitor
2 years ago
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
- Anonymous
  Not applicable
  2 years ago
  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.
Anonymous
Not applicable
2 years ago
Kindly please respond. Y_S
Anonymous
Anonymous
Not applicable
2 years ago
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