Forum Discussion

bsz412's avatar
bsz412
Icon for Helper III rankHelper III
4 years ago
Solved

new icons for conditional formatting

Hi,    I would like to use icons as conditional formatting, and the request I got is to differentiate between  growth ranges:  for 0-10% : 10-50%:  50%-   and same logic for ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    HI  bsz412 ,

    You can achieve this by:

    1.create new column:

    test = IF('Table'[value]<=0.1,UNICHAR(9650),IF('Table'[value]>0.1&&'Table'[value]<=0.5,UNICHAR(9650)&""&UNICHAR(9650),UNICHAR(9650)&""&UNICHAR(9650)&""&UNICHAR(9650)))

    Then set color for it:

    COLOR = IF(MAX('Table'[test])<>BLANK(),"Green",BLANK())

    Final get:

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

HI  bsz412 ,

You can achieve this by:

1.create new column:

test = IF('Table'[value]<=0.1,UNICHAR(9650),IF('Table'[value]>0.1&&'Table'[value]<=0.5,UNICHAR(9650)&""&UNICHAR(9650),UNICHAR(9650)&""&UNICHAR(9650)&""&UNICHAR(9650)))

Then set color for it:

COLOR = IF(MAX('Table'[test])<>BLANK(),"Green",BLANK())

Final get:

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien