Forum Discussion
Helper IHow to created a RAG conditional format on a HH:MM:SS time value?
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?
6 Replies
- MFelix
Super User
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" )
alexw94Is 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
Solution Supplier
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.
- 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?
