Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, i'm trying to use created Measure for icon formatting and use it in table. However, after creating a measure and applying it into conditional formatting options in table, my unichar icons are not being encoded(as below). Does anyone know how to solve that? - I want to stay on this solution - usage of measure for icon conditional formating - as standard conditional based on rules is to limited to do that.
Below my measure, result in table and conditional formatting.
Thanks
Solved! Go to Solution.
Hi, @Anonymous
I have a similar situation here. It seems that field value for icon conditional formating doesn't support for unicode symbol and svg xml (even they can work normally on my table measure column).
As a workaround , you can try to use icon IDs(there are over 60 icons in the built-in icon set) or img url to replace unicode symbols /svg xml.
releted thread: https://community.powerbi.com/t5/Desktop/What-are-the-icon-IDs-In-July-update/m-p/752053
Sample:
VCU icon condition1 =
SWITCH (
TRUE (),
[VCU] < 0, "https://image.emojipng.com/618/3323618.jpg", // url
[VCU] > 0, "https://emojigraph.org/media/emojidex/red-triangle-pointed-down_1f53b.png",
"4CircleLow" //iconid
)
In fact ,you can also try to format by rules without conditional measure for icon formatting.
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
I have a similar situation here. It seems that field value for icon conditional formating doesn't support for unicode symbol and svg xml (even they can work normally on my table measure column).
As a workaround , you can try to use icon IDs(there are over 60 icons in the built-in icon set) or img url to replace unicode symbols /svg xml.
releted thread: https://community.powerbi.com/t5/Desktop/What-are-the-icon-IDs-In-July-update/m-p/752053
Sample:
VCU icon condition1 =
SWITCH (
TRUE (),
[VCU] < 0, "https://image.emojipng.com/618/3323618.jpg", // url
[VCU] > 0, "https://emojigraph.org/media/emojidex/red-triangle-pointed-down_1f53b.png",
"4CircleLow" //iconid
)
In fact ,you can also try to format by rules without conditional measure for icon formatting.
Best Regards,
Community Support Team _ Eason
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 64 | |
| 47 | |
| 41 | |
| 36 | |
| 23 |
| User | Count |
|---|---|
| 185 | |
| 123 | |
| 106 | |
| 78 | |
| 52 |