Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Icons

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

Need Help
  • PaulDBrown's avatar
    PaulDBrown
    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:

     

5 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    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:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion
        4 years ago

        Can you show what you are trying to achieve exactly?