Icons upon Icons

Icons & Custom Icons

I am just bursting with excitement!! This month the amazing Power BI team has yet again come out with a great new feature, Icon sets. In addition to this you can enhance these icon sets by adding your own custom icons to your Power BI reports. Woo Hoo….

So what does this mean? Well, now you have a new Conditional Formatting box found in the settings of the Table and the Matrix properties. To use a built in Icon from Power BI. Create either a table or a Matrix visual with some data.

Select the visual and adjust it’s properties by clicking on the Paint Roller and opening the Conditional Formatting window.

Scroll down until you see the toggle button for Icons. Turn the Icons On.

Click on the Advanced Controls to set the properties of the icons based on the data properties. This type of dialog box should look familiar as it is similar to the previous boxes for conditional formatting. Opening this window shows Icons for each Rule in the list. To adjust an icon Click on the Drop Down Arrow next to the icon you wish to change. There are multiple icons to choose from.

There are limited selections by default, but you can enhance this by adding your own icons with the custom Json theme files. At PowerBI.tips we love our theme files. They make using standard settings so much easier.

Loading the Custom Icons

For starters we have already done the hard work of creating an additional 50 icons for you to use in your reports. Download the Icon Theme File Here

Update: Special thanks to Reid Havens from Havens Consulting for contributing extra icons to this Icon Set.

With this file you get these additional icons:

To add these additional icons follow these steps:

  1. Download the theme file -> Here
  2. Unzip the downloaded file to find the PowerBITips Icons v1.json file
  3. Navigate to the Home ribbon in Power BI Desktop
  4. Click on the Switch Theme button
  5. Select the list item Import Theme from the drop down menu
  6. The open file dialog box will open. Select the PowerBITips Icons v1.json file that you downloaded earlier.

Boom, and just like that you have loaded your new icons. Now you can return to the icons for your table or matrix and adjust until your heart is content.

Here is a sample of a table and a matrix with some custom icons applied:

Update 2019/08/06: When publishing the Power BI file to the PowerBI.com service, the fill colors for the shapes need to have a %23 instead of a # (HASH) infront of the HEX codes. Thus, the format should look like fill=’%23FF0000′ instead of fill=’#FF0000′

If you liked the tables from this blog they came from one of our Layouts that we produce. The Microsoft Layout September 2018, download it here.

If you like the content from PowerBI.Tips please follow us on all the social outlets to stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

12 Comments

    • Arpit, I’ve just rechecked our icons and when I publish the report I can see the icons as expected in the Power BI Service. Is there a specific icon you have tried and it is failing?

      • Hi Seth,
        Your custom icons do work in Edge but not in Chrome, Firefox, Or IE. I created a few SVG icons and they also only work on Edge. This maybe a bug with Microsoft. However, if I used a hosted URL all browsers render my icon correctly.

    • Update 2019/08/06: When publishing the Power BI file to the PowerBI.com service, the fill colors for the shapes need to have a %23 instead of a # (HASH) infront of the HEX codes. Thus, the format should look like fill=’%23FF0000′ instead of fill=’#FF0000′

      This update was genius !!! Was trying to figure this out for days! Thank you so much for this article 🙂

  1. Good day

    Thank you for this post, this is most welcome the icons in Power BI and your post about it.
    I need assistance regarding my images that I want to change to SVG (it is currently PNG). I get the convert from PNG to SVG (currently using https://www.aconvert.com) but where do I get the correct path (the correct SVG path) that one can paste in the JSON theme file?
    Can one use Base64 data image in the JSON Theme File?

    Thank you

1 Trackback / Pingback

  1. Power BI updates, performance and more... (July 22, 2019) | Guy in a Cube

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.