How to add Custom Icons in Power BI conditional formatting

In this blog you will understand – “How to add custom Icons in Power BI conditional formatting?”

By default, Power BI conditional formatting provides some default icons styles as you can see below given screen shot.

But sometimes we need some custom icons in Power BI report as per the project requirement.

Now you can add custom icons styles in Power BI report, following these steps-

Step-1: Make sure you have latest Power BI desktop version.

Step-2: Download the icons which you want to use as a custom icon, you can refer this site for icons – https://icons8.com/

Step-3: Now convert the downloaded icons to Base 64 using Base 64 encoder. You can use this site – https://www.base64-image.de/

Step-4: It will convert your icons into Base 64. After that click on <>Show code & copy the first code.

Step-5: Now create one JSON file, refer below json file basic structure code. In URL section you can paste your icon codes. In same format you can create a code for multiple icons.

Note: You can paste below json code into Notepad file and save notepad file with .Json extension. Exp: CustomIcon.Json

{
"name": "CustomIcons",
"icons": {
"SmileIcon": {
"description": "Icon1",
"url": "Paste your icon 1 code here"
},
"SmileIcon2": {
"description": "Icon2",
"url": "Paste your icon 2 code here if any"
}
}
}

Step-6: See the below final json code-

Step-7: Go to Power BI file View tab > Themes > Browse for Themes > choose Json file > Open.

Note: Make sure you saved file in .Json, Otherwise it will not work.

Once you browse the json file, it will show you to “Imported theme successfully” message.

Step-8: Now go to conditional formatting and choose icons.

Step-9: Now you can see the new added custom icons styles with existing icons.

Refer more Power BI Post – Power BI

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.