Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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/
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |