Forum Discussion
Solved
Using conditional formatting icons for text
I would like to set up conditional formatting on my matrix so that a yellow, red, or green icon shows up in the cell depending on whether the user has completed it or not. If the user has completd it...
Hi, ld17
You can try to use this dax code:
Measure 2 = var _flag= MAX('Table'[Column1]) return SWITCH( TRUE() , _flag="deleted" , 1, _flag="in progress" , 2, _flag="registered",3, IFERROR(DATEVALUE(_flag),-1)<>-1,4 )The configuration need to add '4':
The result is as follows:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks so much for the solution. This works well. One question: if a completed training displays as a date rather than the text "completed," what value should I be putting below?
Hi, ld17
You can try to use this dax code:
Measure 2 = var _flag= MAX('Table'[Column1])
return
SWITCH( TRUE() ,
_flag="deleted" , 1,
_flag="in progress" , 2,
_flag="registered",3,
IFERROR(DATEVALUE(_flag),-1)<>-1,4
)The configuration need to add '4':
The result is as follows:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This works perfect. Thanks so much!