WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn Power BI » Power BI KPI

Power BI KPI

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

By Jeevan A Y

KPI is a key performance indicator and in power bi, there are some specific requirements for this type of KPI visualization, the mandatory requirements are a base context that is used to compare a given value to a target concept which is also known as the threshold.

What is Power BI KPI?

The concept of having KPI in Power BI Dashboards serves in smart ways to analyze the data. Every organization should have an eye on their progress towards the set of standards at the start of every financial or fiscal year. So tracking how business is moving towards its set of targets is the duty of every analyst in the company. Using Power BI visualization we can create this visual to see the real impact of the Target vs Actual report. We will see simple data of every month’s Target vs Actual report to build KPI visual in Power BI.

Power-BI-KPI

Examples to Build KPI Visual in Power BI

To build a KPI visuals, we need sort of data first. Below is the simple data you can use to build KPI visuals.

Power BI KPI - Excel Data

Copy and paste the data directly to Power BI, or you can copy the data to an excel file and then import it to Power BI as an Excel file reference. So you can download the excel workbook template from the below link, which is used for the example of Power BI KPI Visual.

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

I have directly uploaded the excel file to Power BI, and under the “Data” section, I can see this table.

Power BI KPI - Import Excel Data

Example #1 – Simple KPI

Go to the “Report” view and click on the “KPI” visual. For this, we have three sets of data fields to be inserted i.e., “Indicator,” “Trend Axis,” and “Target Goals.”

Power BI KPI - Insert KPI Visual

Indicator: This is nothing but what are the actual values that indicate against the targeted goals.

Trend Axis: This will be our month names or number, which will not show in the horizontal axis.

Popular Course in this category
Sale
Power BI Training Certification
4.5 (521 ratings)
6 Online Courses | 29+ Hours | Verifiable Certificate of Completion | Lifetime Access
View Course

Target Goals: This doesn’t require any special introduction. This will be our target column against the indicator.

  • Now select the inserted power bi KPI Visual. Drag and drop “Fiscal Month” to “Trend Axis,” “Actual” column to “Indicator” and “Target” column to “Target Goals.”

Power BI KPI - Insert Field Values

  • This should create a Power BI KPI chart like the below one.

Power BI KPI - KPI Chart

So, our KPI graph is ready to read. This is a built-in KPI chart. Apart from this, we can install various other charts from the market place of Microsoft.

Example #2 – Dual KPI

Follow the below steps to install custom visuals from the market place.

Step 1: Click on three horizontal dots under visualizations and choose “Import from market place.”

Power BI KPI - Import from Marketplace

Step 2: Now, it will ask you to sing in. You need to use any school or organization id to sign in. If you don’t have an account, it will ask you to sign up.

Sign In Option

Step 3: Once you sign in, it will take you to market place from where we can import custom visuals. You just have to click on the “Add” button to keep adding to your visualization list. Here we have added “Dual KPI” Visual.

Power BI KPI - Marketplace (Add Dual KPI)

After adding, we can see these visuals under the visualization list. Now let’s create a “Dual KPI” chart to show the target vs actual graph.

  • Insert Dual KPI chart visualization.

Insert Dual KPI

  • Now drag and drop the fields, as shown below.

Power BI KPI - Insert Field Values (Dual KPI)

  • So, our Power BI Dual KPI chart will look like this.

Dual KPI Chart

The beauty of this chart is when we hover our cursor, it will show the respective month target and actual values also the variance %.

  • Here, I have placed my cursor on the “September” month, and I could see KPI numbers for this month.

Dual KPI Chart with Values

Like this, we can create KPI charts in Power BI software to visualize target vs actual data.

Note: Power BI KPI Dashboard file can also be downloaded from the link below, and the final output can be viewed.

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

Things to Remember

  • KPI requires proper data to create Power BI KPI visuals.
  • Default KPI often misleads the reader because it doesn’t show the target axis line.
  • You can import custom visuals from market place to create a different kind of KPI charts or visuals.

Recommended Articles

This has been a guide to Power BI KPI. Here we discuss how to build KPI and Dual KPI visual in Power BI Dashboard with the help step by step example. You can learn more about Power BI from the following articles –

  • Data Modeling to get Power BI Reports
  • Reports in Power BI
  • Course for Excel Power User
  • Power BI Beginners Tutorial
  • Power BI Dashboard vs Report
10 Shares
Share
Tweet
Share
Power BI Training Certification
  • 6 Online Courses
  • 29+ Hours
  • Verifiable Certificate of Completion
  • Lifetime Access
LEARN MORE >>

Category iconExcel, VBA & Power BI,  Learn Power BI

Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Download Power BI KPI Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download Power BI KPI Excel Template

Special Offer - Power BI Training Certification (22+ Hours of Training) View More