Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
Solved! Go to Solution.
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
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:
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.
User | Count |
---|---|
82 | |
79 | |
65 | |
48 | |
45 |
User | Count |
---|---|
103 | |
44 | |
39 | |
39 | |
39 |