EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials PowerBI Tutorial Power BI Icon
Secondary Sidebar
PowerBI Tutorial
  • Advanced
    • Power BI Tutorial
    • KPI in Power BI
    • Power BI Calendar
    • Power BI Dashboard Samples
    • Power BI DAX
    • Power BI Filter
    • Power BI Icon
    • Slicers in Power BI
    • Power BI IF Statement
    • Power BI Template
    • Power BI Maps
    • Measures in Power BI
    • Power BI Report
    • Power BI SUMX
    • Power BI Charts
    • Power BI Pie Chart
    • Power BI Bullet Chart
    • Power BI Gantt Chart
    • Power BI Bubble Chart
    • Power BI Waterfall Chart
    • Power BI Drillthrough
    • Power BI Themes
    • Power BI Tooltips
    • Power BI Heat Map
    • Creating Reports in Power BI
    • Power BI Connections
  • Basic
    • What is Microsoft Power BI
    • Is Power BI Free?
    • Power BI Visuals
    • Power BI Parameters
    • Power BI Alternatives
  • Interview Questions
    • Power Bi Interview Questions

Related Courses

Power BI Certification Course

Business Intelligence Certification Course

Data Visualization Certification Course

Power BI Icon

By Priya PedamkarPriya Pedamkar

Power BI Icon

Icons in Power BI Desktop

We all have used conditional formatting in MS Excel and used for the option where we need to change the color of any cell range or inserting arrows or icons as per their trend. In Power BI, we have that option with the name of Power BI Icon. In Power BI, we have some set of icons which we can use in our data. Below is the list of the icon set which is available in Power BI.

Icons Sets of Power BI

To apply Icon in Power BI first we need to convert the data in Table or Matrix chart type in the report tab. And to access the icon follow the below path.

Visualization -> Fields -> Value -> Drop down arrow -> Conditional Formatting -> Icons

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

The above path will be applicable if we apply this into a select Matrix or Table in Report tab.

How to Use Icon in Power BI Desktop?

As we discussed, Power BI Icon works when we convert our data into Table or Matrix. Before we go further first we need data that we will use for Power BI Icon. So you can download the excel workbook from the below link which is used for this example.

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

Below is the data in an excel sheet which has around 1000 line item. As we can see the data shows the sales electronic product Mobile, Laptop, Tablet, and Desktop.

Power BI Icon Example 1-1

  • Now we will upload this data into Power BI. For this, click on Get Data option available under the Home ribbon.

Power BI Icon Example 1-2

  • Select the type of database file we want to connect to Power BI. Here our data is in Excel file. Then click on Connect to proceed further.

Power BI Icon Example 1-3

  • Power BI will ask us to browse the file location. Do that and then Open it.

Power BI Icon Example 1-4

We will get the navigator window where the excel file which we have uploaded will be seen. Now select the sheet name which we want to upload and then click on the Load button.

Power BI Icon Example 1-5

This takes a few moments to complete the activity and our data will be uploaded in Power BI.

  • Now we will convert our uploaded data into Matrix or Table. Let’s select the Matrix chart type from the Visualization section.

Select Matrix chart Example 1-6

  • Here we can create our matrix chart on the basis of Month or Product types. Now, we will put the Product Type in Rows and quantity in the Values field.

Power BI Icon Example 1-7

  • As per the above fields selection, our data will look like as shown below, where we can see each product with their sold quantities.

Power BI Icon Example 1-8

We all know the conditional formatting which we do in Excel. Here also, we will apply the conditional formatting rules for the above Matrix chart.

  • If Quantity sold is greater than equal to 9000 but less than 9200, then color should be Red.
  • If Quantity sold is greater than equal to 9200 but less than 9800, then color should be Yellow.
  • If Quantity sold is greater than in 9800, then color should be Green.

Now to make this happen, we will select the created matrix chart and from the visualization section, click on the drop-down arrow as shown below.

Power BI Icon Example 1-9

  • And from the Conditional formatting option select Icons as shown below.

Conditional formatting option Example 1-10

  • Now as per the above-defined rules, we will create the same here in Conditional Formatting Icon window. In that select the Based field first. Here our based field will be Quantity which we want to color out.

Based on Field Example 1-11

  • Then select the Icon Layout, how you want to see that. Here we will be selecting the Left of Data. This means the icon which we will be selecting further, will be visible on the left side of the data.

Selecting Left of Data Example 1-12

We can choose any type of Color icon to show the value. Here we have selected the default color as shown below.

Type of Color icon Example 1-13

And at the final step, we will put all the defined conditions above, here in the icons as shown below.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,171 ratings)
  • Quantity >= 9000 But <9200
  • Quantity >= 9200 But <9800
  • Quantity >= 9800 But <10000

Now once it is done, then click on Ok.

Power BI Icon Example 1-14

Now we will notice the icon signs will be visible to the left of the data of each product type in the below matrix.

Power BI Icon Example 1-15

So this is how we can use icon in Power BI just like doing conditional formatting.

NOTE: Power BI Icon file can also be downloaded from the link below and the final output can be viewed.
You can download this Power BI Icon Template here – Power BI Icon Template

Pros of Power BI Icon

  • Once the Matrix or Table is created, it is easy to apply and create an icon in the selected chart.
  • We change the position of a defined and created rule in the Icon window.
  • For the person who worked on Condition formatting in MS Excel, using Icon in Power BI will be quite easy.

Things to Remember

  • There is no limit to defining rules in icon. We can create any number of rules in Power BI Icon.
  • In the Icon layout, it is recommended to use the Left of data option, so that it will be easy for viewers to distinguish between value and icon and their relation between each other.
  • An icon can only be implemented in Table and Matrix-type visualization in Power BI. If there is no such chart, then we need to convert the data in the required format.

Recommended Articles

This is a guide to Power BI Icon. Here we discuss how to use desktop power bi Icon sets in Conditional Formatting along with a practical example. You may also look at the following articles to learn more –

  1. Power BI Tutorial For Beginners
  2. How to Use DAX Formula in Power BI?
  3. Difference Between Power BI Dashboard vs Report
  4. How to Use Icon Sets in Excel?
  5. How to Use Calendar DAX Function in Power BI?
  6. Power BI IF Statement
  7. How to Use Filter DAX Function in Power BI?
  8. Creating Sample Dashboard in Power BI
  9. Power BI Charts | How to Create?
  10. Power BI Connections | Types
Popular Course in this category
Microsoft Power BI Training (6 Courses, 4 Projects)
  6 Online Courses |  4 Hands-on Projects |  45+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Power BI Icon Excel Template

EDUCBA

Download Power BI Icon Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more