new icons for conditional formatting

[bsz412]

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!

[v-luwang-msft · Accepted solution]

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

[amitchandak]

@bsz412 , Follow the Star Rating blog and use a different unichar. Also, change logic as per need

https://community.powerbi.com/t5/Quick-Measures-Gallery/Star-Ratings/m-p/166903

https://www.c-sharpcorner.com/article/add-star-rating-in-power-bi-desktop-using-dax-expression/