Home » Power BI » How to add Custom Icons in Power BI conditional formatting

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.

Default Power BI Icons

Default Power BI Icons

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/

icons8 site

icons8 site

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

Base 64

Base 64




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

Copy Base 64 code

Copy Base 64 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-

Json file code

Json file 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.

import theme message

import theme message

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

Conditional formatting icons

Conditional formatting icons




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

Custom Icons

Custom 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.

2 thoughts on “How to add Custom Icons in Power BI conditional formatting”

Leave a Reply