Conditional format time in matrix - using dax

[cottrera]

Hi

I have a matix visual that contains peoples names in the first column, dates across the header row and the values are times hh:mm:ss.  I would like to conditionally format the time values if they meet the criteria below. I am asuming this woud have to be done in dax

Before 16:00:00 = Red

Between 16:00:00 - 17:00:00 = Orange

Between 17:00:00 - 17:30:00 = Green

Between 17:30:00-18:00:00 = Blue

After 18:00:00 = Grey

Example of matrix

Alan	17:25:35	17:48:11	17:48:11
Alistair	16:49:32	17:06:17	17:06:17
Andrew	19:15:00	23:30:00	23:30:00
Anthony	17:34:35	17:32:35	17:34:35
Bradley	00:00:00	23:30:00	23:30:00
Carl	17:54:21	18:02:34	18:02:34
Curtis	17:41:43	16:48:43	17:41:43
Dave	18:01:08	17:24:59	18:01:08

thank you Richard

[cottrera]

Works perfectly thank you as always😁

[amitchandak · Accepted solution]

@cottrera , Create a color measure like

Switch(True(),
max([time]) =<time(16,0,0) , "red",
max([time]) >time(16,0,0) && max([time]) =<time(17,0,0), "Green",
max([time]) >time(17,0,0) && max([time]) =<time(18,0,0), "Blue",
"grey"
)

use that in conditional formatting with field value option

refer for steps :

https://www.youtube.com/watch?v=RqBb5eBf_I4

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values