Conditional format time in matrix - using dax

Question

Hi&nbsp;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.&nbsp; 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 daxBefore 16:00:00 = RedBetween 16:00:00 - 17:00:00 = OrangeBetween 17:00:00 - 17:30:00 = GreenBetween 17:30:00-18:00:00 = BlueAfter 18:00:00 = Grey&nbsp;Example of matrix&nbsp;Alan17:25:3517:48:1117:48:11Alistair16:49:3217:06:1717:06:17Andrew19:15:0023:30:0023:30:00Anthony17:34:3517:32:3517:34:35Bradley00:00:0023:30:0023:30:00Carl17:54:2118:02:3418:02:34Curtis17:41:4316:48:4317:41:43Dave18:01:0817:24:5918:01:08&nbsp;thank you Richard

amitchandak · Accepted Answer

cottrera , Create a color measure like
&nbsp;
Switch(True(),max([time]) =&lt;time(16,0,0) , "red",max([time]) &gt;time(16,0,0) &amp;&amp; max([time]) =&lt;time(17,0,0), "Green",max([time]) &gt;time(17,0,0) &amp;&amp; max([time]) =&lt;time(18,0,0), "Blue","grey")
&nbsp;
use that in conditional formatting with field value option
&nbsp;
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-numbers-in-the-columnhttps://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Forum Discussion

Conditional format time in matrix - using dax

2 Replies

Related content

Matrix Row Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting with Matrix Table

Conditional Formatting

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