Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Time values with text format and conditional background color format required! Help me pls?

Hi Team,

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.

I have created 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.
Still getting below error. like below snapshot with data type error.

 

Kindly help me please!
Thanks in advance.

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hey, could you give this a try:
    HighlightTime =
    VAR _time = SELECTEDVALUE('Table'[Column1])
    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

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Anonymous ,

    Anonymous  nice method！And here's my solution on cell elements format.

    Here is my test data:

    1.Create a measure

     

     

     

     

    HighlightTime =
VAR _time =
    TIMEVALUE ( SELECTEDVALUE ( 'Table'[Column1] ) )
VAR _highlight =
    IF ( _time >= TIME ( 0, 0, 0 ) && _time < TIME ( 2, 0, 0 ), 0, 1 )
RETURN
    _highlight

     

     

     

     

    2.Formatting cells

    Go to Format Visual ->Format your visual

     ->cell elements and apply measure as a function of background color

     

    3.Final output

     

    Best Regards,
    Albert He

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Anonymous ,

    Anonymous  nice method！And here's my solution on cell elements format.

    Here is my test data:

    1.Create a measure

     

     

     

     

    HighlightTime =
VAR _time =
    TIMEVALUE ( SELECTEDVALUE ( 'Table'[Column1] ) )
VAR _highlight =
    IF ( _time >= TIME ( 0, 0, 0 ) && _time < TIME ( 2, 0, 0 ), 0, 1 )
RETURN
    _highlight

     

     

     

     

    2.Formatting cells

    Go to Format Visual ->Format your visual

     ->cell elements and apply measure as a function of background color

     

    3.Final output

     

    Best Regards,
    Albert He

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks! All looks great on the cell formatting too, hopefully this gives the user a solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hey, could you give this a try:
    HighlightTime =
    VAR _time = SELECTEDVALUE('Table'[Column1])
    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you so much Anonymous Anonymous 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      No problem at all, happy that we could give a solution 🙂