Forum Discussion
Custom Icons
- 4 years ago
Unichar makes it simple to include UNICODE symbols in reports. For example the following:
UNICHAR 9013 = UNICHAR(9013)delivers
So you can use UNICHAR expressions directly in measures for conditional formatting.
If you want to use specific images, try:
You need to host the icons on a publicly accessible website/hosting service. (for the prupose of this example, I've just referenced images on the web).
Create a table including the URL to each image and an index column:
Set the Image URL column to type "Image URL"
Create the conditional format measure
Custom Icons = SWITCH ( TRUE (), [Sum of Sales] > 25800, LOOKUPVALUE ( 'Icon Table'[Image], 'Icon Table'[Index], 1 ), [Sum of Sales] < 24000, LOOKUPVALUE ( 'Icon Table'[Image], 'Icon Table'[Index], 2 ), LOOKUPVALUE ( 'Icon Table'[Image], 'Icon Table'[Index], 3 ) )And you will get the following:
- Anonymous4 years agoNot applicable
Paul can you elaborate a bit. I have 5 SVG files, I need to transform to icons. How can Unichar help with that?
- PaulDBrown4 years agoCommunity Champion
Can you show what you are trying to achieve exactly?
- Anonymous4 years agoNot applicable
I want to use the attached images as custom icons. This to depict the importance of project tasks in a table. So basically conditional formatting is what i want to achieve with the images.