Unable to conditional format a column which has a time value like this one "07:09"

Anonymous , not sure on this , but you can create a measure like

Switch( True() ,

Max(table[timecol]) <time(7,0,0) , "green" ,

Max(table[timecol]) <time(13,0,0) , "blue" ,

"red"

)

and use that is conditional formatting with field value option

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

Hi Anonymous ,

Please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

For now, you could refer to:

Use conditional formatting in tables

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.