Power BI Icons

Updated on January 2, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What is a Power Bi Icon Set?

Icons are the visual representation of any content or a data header. In Power BI, some built-in icons that any user can use. Also, we have options to make custom-made icons in Power BI. It is a new feature that has been added to Power BI.

Icon sets are similar to those we used on Excel conditional formatting. Icon sets represent the data through icons available in Power BI.

Icons

We are sure you have enjoyed the thing “Conditional FormattingConditional FormattingConditional formatting is a technique in Excel that allows us to format cells in a worksheet based on certain conditions. It can be found in the styles section of the Home tab.read more” brings to the table in Excel. By setting our conditions, we can decide the formatting style for our numbers. We can do the same with Power BI visualizationPower BI VisualizationIn Power Bi, there are some built-in visuals for data visualization, as well as some custom visuals. Custom visuals are user-defined and allow users to use their own creativity in terms of how they want to present data. For example, one can use lines and dots in a flashing and floating manner to display changes in data over time.read more if you use advanced conditional formatting in Excel.

Now, many of those who use Power BI are unaware that we can apply conditional formatting in Power BIConditional Formatting In Power BIConditional formatting is a feature that uses different colours to highlight cells in a data set based on specific or different conditions. It can be found in both Microsoft Excel and Power Bi.read more. For example, we can apply icon sets to our data set numbers using these visuals. This article will show you how to use “Power BI Icon Set” to apply conditional formatting.

Power-BI-Icons

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Power BI Icons (wallstreetmojo.com)

History of Power Bi Field Icon Set

First thing first, “Icon Sets” in Power BI can be applied to “Table” and “Matrix” visuals. In July 2019, Microsoft released this new feature for Power BIFeature For Power BIPower BI has countless appealing features like content packs (containing data models & dashboards, etc.), personalized visualization, DAX functions, Flexible Tiles, and Quick Insights, among others.read more. So, download and install the latest version to use the “Conditional Formatting” in Power BI.

Based on users’ feedback and ideas, Microsoft improves its product features every month, and here you go, “Icon Set” is one of them.

–>> If you want to learn Power BI professionally, then Power BI Basics Course (5+ hours) is the perfect solution. This course will introduce you to a wide range of Power BI concepts like collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights, Creating Reports in Power BI Desktop, Analyze Data with Excel, Graphs & Visualizations, Interactive Dashboards along with some real life examples.

How to Apply an Icon Set in Power Bi?

You can download the workbook used in this example to practice with us.

You can download this Power BI Icons Excel Template here – Power BI Icons Excel Template

As we said, conditional formatting can be applied to the “Table” and “Matrix” visual. To demonstrate the icon set in this article, we have created a simple “Table” visual below.

power bi icon (table values)

We will apply the “Icon Set” for this table based on the below rules.

  • If the Amount is <=195, the icon will be the “Red” color icon.
  • If the Amount is >=196 and <=200, the icon will be in “Yellow.”
  • If anything >200, then the color will be “Green.”

Applying “Icon Set” to select the “Table” visual will show the fields used from the table to create this visual.

power bi icon (values)
  • Since our numbers are in a table based on “Amount,” click on the dropdown list “Amount” and choose “Conditional formatting.”
power bi icon (Conditional Formatting)
  • So, choose “Icons” from the “Conditional formatting” options to open the below windows.
power bi icon (icons window)
  • In this, we need to define our rule, so make sure we select the “Format by” dropdown list with “Rules.”
power bi icon (format by rules)
  • We need to select based on which field of the table we are applying icons, so select the “Sum of amount” column under the “Based on field” option.
Power bi icon (based on field)

Next, we must select the kind of summarization we need to apply. From this dropdown list, we can choose “Overall Sum Value,” “Average,” “Minimum,” “Maximum,” etc. Like this, we can choose many options, as shown below.

  • Since we need icons based on the overall value, I have chosen “Sum.”
Power bi icon (Sum)
  • Now, we need to choose the icon’s position in the table. From this dropdown, we can choose the icon’s position as “Right of data” or “Left of data.” You can choose the “Icon Only” option if you want to see only icons.
layout
  • Next, we must choose the “Icon alignment” position as “Top,” “Middle,” or “Bottom.”
Alignment
  • Now comes the icon part. Under “Style,” we can choose what kind of icon we need to show on the table.
Style
  • As you can see above, we have several icons available. You can choose any of them based on the data. Since we have only three rules, we have chosen the icon below.
Style choosen

Now, we need to apply the rules we defined earlier.

  • We will go from bottom to top. But, first, we will define the rule as follows.
Values range

Now, let me explain the rule to you.

“If the value is >= 0 (percent) and <= 40 (percent) then we need “Red” color traffic signal”.

“If the value is >= 41 (percent) and <= 70 (percent) then we need “Yellow” color traffic signal”.

“If the value is >= 71 (percent) and <= 100 (percent) then we need “Green” color traffic signal”.

  • Click on “OK.” We should get traffic lights as per the defined rule.
Power bi icons (Table with icon sets)

We got our first-ever icon set in Power BI.

Like this, you can use other icon sets to apply conditional formatting for the data in Power BI.

Note: We can also download the Power BI icon file from the link below. We can view the final output.

You can download this Power BI Icons Template here – Power BI Icons Template

Things to Remember Here

This article is a guide to Power BI Icons. Here, we discuss using the Power BI icon set to apply conditional formatting in given data, along with examples. You can learn more about Power BI from the following articles: –