Forum Discussion

ld17's avatar
ld17
Icon for Helper II rankHelper II
3 years ago
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...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

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

ld17's avatar
ld17
Icon for Helper II rankHelper II
3 years ago

This works perfect. Thanks so much!