How to created a RAG conditional format on a HH:MM:SS time value?

[alexw94]

So I have a table of data which contains times. I want the table of times to display a background colour behind the value as either Red, Amber or Green. It will work as follows.

00:00:00 > <= 00:20:00 = Green

00:20:00 > <= 00:22:00 = Amber

Anything greater  than 00:22:00 = Red

I want to set colours through the conditional formating tool to show the above. Conditional formating values on Power BI seem to only work as a numerical value or percentage. As time is neither of these, i am unable to do conditional formating.

Can anybody suggest a way in which this can be done please?

[alexw94]

@ghoshabhijeet @GH  this is what I am trying to do, see attached screenshot of power bi data table, also see attached key for RAG colours, please can you help?

[MFelix]

Hi @alexw94 ,

Power BI has a formula that is time you can create something similar to this:

Color =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table (3)'[Time] ) > TIME ( 0, 0, 0 )
        && SELECTEDVALUE ( 'Table (3)'[Time] ) <= TIME ( 0, 20, 0 ), "#4CAF50",
    SELECTEDVALUE ( 'Table (3)'[Time] ) > TIME ( 0, 20, 0 )
        && SELECTEDVALUE ( 'Table (3)'[Time] ) <= TIME ( 0, 22, 0 ), "#FFC107",
    SELECTEDVALUE ( 'Table (3)'[Time] ) > TIME ( 0, 22, 0 ), "#F44336"
)

[alexw94]

Is this a measure what you have created? If so, the measure is not picking up the time values in my data table, the time values I have in my data table are from another measure. 

[ghoshabhijeet]

@alexw94  Thanks for your query. Please provide some sample data.

[alexw94]

I will try, it will be difficult. 

[ghoshabhijeet]

@alexw94  If you wish you can share some sample data. May be I can help.