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 negative numbers with the red triangle pointing down. 

 

I found these icons in conditional formatting:

Can you please help me how to create this conditional formatting?

thank you!

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

2 Replies