Forum Discussion
Conditional format time in matrix - using dax
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values