EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

KPI in Power BI

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » PowerBI Tutorial » KPI in Power BI

KPI in Power BI

Introduction to Power BI KPI

KPI (Key Performance Indicators) are those parameters that help us to analyze the data. Every data we want to use in Power BI has some parameters or KPI that drive the graph’s figures we want to see. We should monitor the KPIs of the data to analyze the changes, growth, downfall in the data. These KPIs become measurement points as well and help us in tracking the business. With the help of KPI visuals in Power BI, we can actually get the points that we want to hit to improve the business. We actually see, what target we have fixed and what actual figures we are getting on charts with the KPIs.

Types of KPI in Power BI Dashboard

There are 2 types of KPIs in Power BI.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

1. Single KPI: Single KPI has 3 sets of fields which are Indicator, Trend Axis and Target Goal.

Where,

  • Indicators: Shows the actual values against targeted values.
  • Trend Axis: This should be the month name or number axis line.
  • Target Goal: Shows the target which is to be achieved.

2. Dual KPI: Dual KPI has Axis, Top Value and Bottom Values.

Where,

  • Axis: Has the month name or number.
  • Top and Bottom Values: These are Top and Bottom values from the single KPI chart.

How to Use KPI Visuals in Power BI?

Below are the different examples to use KPI visuals in Power BI dashboard:

KPI in Power BI – Example #1

In this example, we will see Single KPI. For this, we have data as shown below. So you can download the excel workbook from the below link which is used for this example.

You can download this KPI in Power BI Excel Template here – KPI in Power BI Excel Template

Where we have Month Number, Month, Actual and Target Value. All these values are required as per the fields therein Single KPI as we have seen above.

Popular Course in this category
Sale
Microsoft Power BI Training (4 Courses, 3 Projects)4 Online Courses | 3 Hands-on Projects | 32+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (9,177 ratings)
Course Price

View Course

Related Courses
Business Intelligence Training (12 Courses, 6+ Projects)Data Visualization Training (15 Courses, 5+ Projects)

Power BI KPI Example 1-1

  • Go to Power BI and click on Get Data option as shown below.

Power BI KPI Example 1-2

  • Select the excel file as shown below and Connect.

Power BI KPI Example 1-3

  • Browse and select the file.

Power BI KPI Example 1-4

  • Check the Sheet name which has the data. Here our sheet is Sheet1. After that click on the Load button as shown below.

Load the Sheet Example 1-5

  • We will be able to see the uploaded data header’s name in the Fields section.

Fields section Example 1-6

  • Select KPI visualization type from the Visualization section as shown below. We will see the preview of the KPI chart in the report screen only.

Power BI KPI Example 1-7

We can here increase and adjust the size of the KPI chart as per our requirement.

  • Now as we have seen at the start of the article, as per that we will now drag the related fields into the relevant sections as shown below.

Power BI KPI Example 1-8

  • Once we do that, we will see our Single KPI chart got the values in it.

Power BI KPI Example 1-9

This is the final Single KPI Chart which is built in Power BI.

KPI In Power BI – Example #2

Dual KPI chart is not built in Power BI visualization and not easy to access. For this, you need to click on 3 dots at the bottom of Visualization as shown below. This will give us a list of sources from where we can add new visualizations. Now select Import From Marketplace option.

Import From Marketplace

  • A Sign-in window will appear which will ask us to Sign in or Login. If you are working in an organization then you can sign in using your company credentials or else any student login id of Outlook will also work here.

Power BI KPI Example 2-2

  • Once we do that, this will take us to Power BI Visuals Market Place as shown below. This is the place where we can select any visuals we want and add them to our list.

Power BI Visuals Market Place

  • In the search box, search Dual KPI and click on Add as shown below.

Power BI KPI Example 2-4

  • After that, we will be able to find the Dual KPI visuals in the Visualization section of Power BI as shown below. Now select the Dual KPI from visualization.

Dual KPI visualization Example 2-5

  • Dual KPI Chart looks like as shown below. This chart has 2 KPI charts which are drawn by the main chart located at the bottom of it.

Dual KPI Chart Example 2-6

  • Now we will drag and add respective fields here as shown below.

Power BI KPI Example 2-7

  • Our Dual KPI chart will look like this as shown below. As we can see, the chart has Actual and Target value graphs separately above and below. By this, we can easily compare the Actual and Target values.

Power BI KPI Example 2-8

And the good thing about this chart is when we move the cursor over the chart, we will be able to see Actual and Target values together at any point.

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

Pros & Cons of KPI in Power BI Dashboard

  • This is quite good at comparing the 2 sets of fields Actual and Target easily.
  • Single KPI charts are easy to implement.
  • We can see the change of data when we move a cursor on the graphs.
  • Those who don’t have login ID may not able to add new visualization from Market Place.

Things to Remember

  • Dual KPI Chart is not by default available in visualization. We need to download and add additional charts from Power BI Market Place for further use.
  • It is recommended to use Dual or Multi KPI charts over single or default KPI chart. Because Dual or Multi KPI charts give more accurate values at all points.
  • We can import any custom visual from Market Place.
  • We can insert the data by copy-pasting the values into the cell if the input file has very less data as seen in the above examples.
  • While working with huge data, always save the file in Power BI on different multiple intervals to avoid losing the data.
  • Dual KPI charts don’t allow us to use the Month name. It always prefers the month number.

Recommended Articles

This is a guide to KPI in Power BI Dashboard. Here we discuss how to use Power BI KPI (Key Performance Indicator) Visuals along with a practical example. You may also look at the following articles to learn more –

  1. Guide to Power BI Reports
  2. Power BI DAX with Example
  3. How to Use Filter DAX Function in Power BI?
  4. Creating Sample Dashboard in Power BI

Microsoft Power BI Training (3 Courses, 3 Projects)

4 Online Courses

3 Hands-on Projects

32+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary 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

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

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

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
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 Login

Forgot Password?

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

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

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

Independence Day Offer - Microsoft Power BI Training (3 Courses, 3 Projects) Learn More