Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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
@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/