Custom Icons

[Anonymous]

Hi Guys 

I am trying to create custom icons for my table in Power Bi. This to illustrate "priority" of a given project task.

I have tried to find inspiration and done j.son, but for some reason it does not work. 

Does somebody have a solution to implement custom icons? 

Best Regards

[PaulDBrown · Accepted solution]

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:

[PaulDBrown]

you can use UNICHAR to customise icons

https://docs.microsoft.com/en-gb/dax/unichar-function-dax 

[Anonymous]

@Paul can you elaborate a bit. I have 5 SVG files, I need to transform to icons. How can Unichar help with that?

[PaulDBrown]

Can you show what you are trying to achieve exactly?

[Anonymous]

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.