50 Power BI KPIs by Department: Free KPI Cheat Sheet

A Power BI dashboard is only as useful as the KPIs behind it. The right KPI tells a team whether performance is improving, falling behind target, or requiring immediate attention.

But there is no universal list of KPIs that works for every business. A sales manager may need revenue, win rate, and pipeline coverage, while a CFO may focus on gross margin, operating expenses, and cash flow. HR may care about employee turnover and time to hire, while supply chain teams need inventory turnover, order fulfillment, and supplier performance.

This guide gives you 50 practical Power BI KPIs across 10 major business departments, including Sales, Finance, Marketing, HR, Supply Chain, Operations, Healthcare, Customer Service, Ecommerce, and Executive Management.

The goal is not to put 50 numbers on one dashboard. Instead, use this as a Power BI KPI cheat sheet to identify the metrics that actually support your team's decisions.

Quick answer: The best Power BI KPIs connect a measurable business outcome with a target, time period, and meaningful comparison. Microsoft describes a KPI as a visual way to measure progress toward a measurable goal, typically using an indicator, target, and threshold or goal.

Free Power BI KPI Cheat Sheet

Department	KPI	What It Measures
Sales	Revenue	Total sales generated
Sales	Sales Growth Rate	Revenue growth over time
Sales	Win Rate	Percentage of opportunities won
Sales	Average Deal Size	Average revenue per closed deal
Sales	Sales Target Achievement	Actual sales versus target
Finance	Gross Profit Margin	Profitability after direct costs
Finance	Operating Expense Ratio	Operating expenses relative to revenue
Finance	Net Profit Margin	Net income as a percentage of revenue
Finance	Cash Conversion Cycle	Time required to convert operations into cash
Finance	Accounts Receivable Days	Average time to collect receivables
Marketing	Conversion Rate	Percentage of visitors/leads that convert
Marketing	Cost Per Lead	Marketing cost for each lead
Marketing	Customer Acquisition Cost	Cost to acquire a customer
Marketing	Return on Ad Spend	Revenue generated per advertising dollar
Marketing	Marketing Qualified Leads	Leads meeting marketing qualification criteria
HR	Employee Turnover Rate	Percentage of employees leaving
HR	Absenteeism Rate	Employee absence relative to available work time
HR	Time to Hire	Average hiring time
HR	Cost per Hire	Average cost of recruiting an employee
HR	Employee Retention Rate	Percentage of employees retained
Supply Chain	Inventory Turnover	How often inventory is sold/replaced
Supply Chain	Stockout Rate	Frequency of unavailable inventory
Supply Chain	Order Fulfillment Rate	Orders fulfilled successfully
Supply Chain	Supplier On-Time Delivery	Supplier delivery reliability
Supply Chain	Perfect Order Rate	Orders delivered accurately and on time
Operations	Overall Equipment Effectiveness	Equipment productivity
Operations	Production Yield	Percentage of output meeting requirements
Operations	Downtime Rate	Time lost due to equipment/process downtime
Operations	Cycle Time	Time required to complete a process
Operations	Capacity Utilization	Used capacity versus available capacity
Healthcare	Patient Volume	Number of patients served
Healthcare	Average Length of Stay	Average patient stay duration
Healthcare	Readmission Rate	Patients returning within a defined period
Healthcare	Wait Time	Average patient waiting time
Healthcare	Bed Occupancy Rate	Percentage of available beds occupied
Customer Service	First Response Time	Time before a customer receives a response
Customer Service	Average Resolution Time	Time required to resolve a case
Customer Service	First Contact Resolution	Cases resolved during the first interaction
Customer Service	Customer Satisfaction Score	Customer satisfaction level
Customer Service	SLA Compliance Rate	Cases resolved within agreed service levels
Ecommerce	Conversion Rate	Visitors who complete a purchase
Ecommerce	Average Order Value	Average value of each order
Ecommerce	Cart Abandonment Rate	Carts created but not purchased
Ecommerce	Customer Lifetime Value	Expected customer revenue over the relationship
Ecommerce	Repeat Purchase Rate	Customers who purchase again
Executive	Revenue Growth	Overall business growth
Executive	EBITDA Margin	Operating profitability
Executive	Customer Acquisition Cost	Cost of acquiring customers
Executive	Customer Lifetime Value	Long-term customer value
Executive	Cash Flow	Cash generated and consumed by the business

---

What Makes a KPI Useful in Power BI?

A KPI should answer a business question.

For example:

Revenue = $2.5M

This is a metric.

But:

Revenue = $2.5M vs $2.2M target

is much more useful because it provides context.

An effective KPI normally includes:

• Current value: Where are we now?

• Target: Where should we be?

• Variance: How far are we from the target?

• Trend: Are we improving or declining?

• Time period: When did the change happen?

• Context: Which product, region, customer, employee group, or process caused it?

This is why simply filling a Power BI dashboard with KPI cards does not automatically create a useful analytics solution.

Microsoft's Power BI documentation specifically notes that KPI visuals are designed to measure progress toward a goal and require a base measure, target and threshold or goal.

1. Sales KPIs

Sales teams need KPIs that connect activity to revenue. A good sales dashboard should help managers understand not only how much was sold, but also why sales changed and where future revenue is coming from.

1. Revenue

Formula:
Revenue = Total Sales Value

Tracks the total value generated during a selected period.

In Power BI, revenue should ideally be analyzed by product, salesperson, territory, customer segment, and time period.

2. Sales Growth Rate

Formula:
Sales Growth % = (Current Sales - Previous Sales) / Previous Sales × 100

Shows whether revenue is growing or declining compared with a previous period.

3. Win Rate

Formula:
Win Rate = Won Opportunities / Total Closed Opportunities × 100

Useful for evaluating sales effectiveness and comparing performance across representatives, products, or regions.

4. Average Deal Size

Formula:
Average Deal Size = Total Won Revenue / Number of Won Deals

A rising average deal size can indicate larger contracts or changes in the customer mix.

5. Sales Target Achievement

Formula:
Target Achievement % = Actual Sales / Sales Target × 100

This is particularly useful for sales manager dashboards because it immediately shows which teams or territories are ahead or behind target.

2. Finance KPIs

Finance dashboards should go beyond revenue. Finance leaders typically need visibility into profitability, costs, working capital, and cash.

6. Gross Profit Margin

Formula:
Gross Profit Margin = (Revenue - COGS) / Revenue × 100

Shows how much revenue remains after direct costs.

7. Operating Expense Ratio

Formula:
Operating Expense Ratio = Operating Expenses / Revenue × 100

Helps finance teams monitor whether operating costs are increasing faster than revenue.

8. Net Profit Margin

Formula:
Net Profit Margin = Net Income / Revenue × 100

Shows how much of every unit of revenue remains after expenses, interest, taxes, and other applicable costs.

9. Cash Conversion Cycle

The cash conversion cycle measures how long cash is tied up in inventory and receivables after accounting for supplier payment timing.

A common formula is:

CCC = DIO + DSO - DPO

Where:

• DIO = Days Inventory Outstanding

• DSO = Days Sales Outstanding

• DPO = Days Payable Outstanding

10. Accounts Receivable Days

Formula:
AR Days = Average Accounts Receivable / Credit Sales × Number of Days

This helps finance teams monitor how quickly customers are paying invoices.

3. Marketing KPIs

Marketing KPIs should connect campaigns and channels to measurable business outcomes.

A Power BI marketing dashboard can combine advertising, website, CRM, and sales data instead of evaluating each channel separately.

11. Conversion Rate

Formula:
Conversion Rate = Conversions / Visitors or Leads × 100

The denominator should be clearly defined because visitor-to-lead and lead-to-customer conversion rates answer different questions.

12. Cost Per Lead

Formula:
CPL = Marketing Spend / Number of Leads

Useful for comparing campaign and channel efficiency.

13. Customer Acquisition Cost

Formula:
CAC = Total Sales & Marketing Cost / New Customers Acquired

CAC becomes more meaningful when viewed alongside customer lifetime value.

14. Return on Ad Spend

Formula:
ROAS = Attributed Revenue / Advertising Spend

Useful for evaluating paid advertising performance.

15. Marketing Qualified Leads

MQL volume measures the number of leads meeting your defined marketing qualification criteria.

The important part is not simply increasing MQLs. In Power BI, connect MQLs to SQLs, opportunities, customers, and revenue to determine whether lead quality is improving.

Microsoft's own Sales and Marketing sample demonstrates how Power BI can combine measures such as market share, sales volume, sentiment, and regional performance to provide business context rather than displaying isolated numbers.

4. HR KPIs

HR analytics can turn employee data into workforce planning insights.

16. Employee Turnover Rate

Formula:
Turnover Rate = Employees Who Left / Average Employee Count × 100

Analyze this by department, tenure, job role, location, and employment type.

17. Absenteeism Rate

Formula:
Absenteeism Rate = Unscheduled Absence Days / Available Workdays × 100

Helps identify workforce availability patterns.

18. Time to Hire

Measures the average number of days required to fill an open position.

Break it down by job role, recruiter, department, and hiring source.

19. Cost per Hire

Formula:
Cost per Hire = Total Recruitment Cost / Number of Hires

Recruitment costs can include advertising, agencies, technology, assessment, and other defined hiring expenses.

20. Employee Retention Rate

Formula:
Retention Rate = Employees Remaining During Period / Employees at Start of Period × 100

Retention should ideally be analyzed alongside turnover rather than treated as an isolated number.

Microsoft's current Power BI sample library includes HR examples covering metrics such as headcount, turnover, workforce distribution, hiring trends, and tenure.

5. Supply Chain KPIs

Supply chain dashboards need to balance inventory availability, cost, supplier performance, and fulfillment.

21. Inventory Turnover

Formula:
Inventory Turnover = Cost of Goods Sold / Average Inventory

A higher turnover rate can indicate faster inventory movement, but the appropriate level depends on the business and product category.

22. Stockout Rate

Formula:
Stockout Rate = Stockout Events / Total Demand Events × 100

Shows how frequently products are unavailable when needed.

23. Order Fulfillment Rate

Formula:
Fulfilled Orders / Total Orders × 100

Measures the percentage of orders successfully fulfilled.

24. Supplier On-Time Delivery

Formula:
On-Time Supplier Deliveries / Total Supplier Deliveries × 100

Use this KPI to compare supplier reliability.

25. Perfect Order Rate

A perfect order is typically one that is delivered:

• On time

• Complete

• Without damage

• With accurate documentation

The exact definition should be standardized within the organization before building the Power BI measure.

Power BI's sample datasets also include procurement, supplier quality, retail, inventory, and regional sales scenarios, reinforcing the importance of department-specific metrics rather than one generic KPI framework.

6. Operations KPIs

Operations dashboards should help managers identify bottlenecks, production losses, quality problems, and unused capacity.

26. Overall Equipment Effectiveness

OEE is commonly calculated as:

OEE = Availability × Performance × Quality

It provides a combined view of equipment availability, production speed, and quality output.

27. Production Yield

Formula:
Yield = Good Units Produced / Total Units Produced × 100

Shows the percentage of production meeting quality requirements.

28. Downtime Rate

Formula:
Downtime Rate = Downtime / Planned Production Time × 100

Track downtime by machine, production line, shift, and reason.

29. Cycle Time

Measures how long it takes to complete a process or produce a unit.

Power BI can make cycle-time analysis more useful by showing median, average, percentile, and trend values.

30. Capacity Utilization

Formula:
Capacity Utilization = Actual Output / Maximum Available Capacity × 100

Useful for identifying underused or overloaded production capacity.

7. Healthcare KPIs

Healthcare analytics requires careful KPI definitions because operational efficiency and patient outcomes can both matter.

31. Patient Volume

Measures the number of patients served during a defined period.

Break it down by department, specialty, physician, location, or service type.

32. Average Length of Stay

Formula:
Average LOS = Total Inpatient Days / Number of Discharges

Useful for understanding hospital utilization and patient flow.

33. Readmission Rate

Formula:
Readmission Rate = Eligible Readmissions / Eligible Discharges × 100

The exact readmission window and eligibility criteria should be defined before calculating the KPI.

34. Average Wait Time

Measures the average time patients wait before receiving a defined service.

Median and percentile wait times can provide additional context because averages may hide extreme delays.

35. Bed Occupancy Rate

Formula:
Bed Occupancy Rate = Occupied Bed Days / Available Bed Days × 100

This helps healthcare organizations monitor capacity utilization.

8. Customer Service KPIs

Customer service dashboards should reveal whether teams are responding quickly and resolving issues effectively.

36. First Response Time

Measures the time between a customer raising an issue and receiving the first meaningful response.

37. Average Resolution Time

Formula:
Average Resolution Time = Total Resolution Time / Resolved Cases

Track this by issue type, agent, priority, and channel.

38. First Contact Resolution

Formula:
FCR = Cases Resolved During First Contact / Total Cases × 100

A high FCR can indicate that customers are getting solutions without repeated interactions.

39. Customer Satisfaction Score

CSAT is generally calculated from customer survey responses according to the organization's defined scoring method.

Always document the survey population, response window, and scoring methodology.

40. SLA Compliance Rate

Formula:
SLA Compliance = Cases Meeting SLA / Total Eligible Cases × 100

This is particularly useful for support teams working under contractual or internal service-level commitments.

9. Ecommerce KPIs

Ecommerce teams need visibility across the complete customer journey, from traffic to purchase and repeat buying.

41. Ecommerce Conversion Rate

Formula:
Conversion Rate = Orders / Website Sessions × 100

Track it by device, traffic source, product category, geography, and customer type.

42. Average Order Value

Formula:
AOV = Total Revenue / Number of Orders

AOV can help ecommerce teams understand whether customers are purchasing higher-value baskets.

43. Cart Abandonment Rate

A common formula is:

Cart Abandonment Rate = (Carts Created - Completed Orders) / Carts Created × 100

Define the attribution window consistently.

44. Customer Lifetime Value

CLV estimates the economic value generated by a customer over the relationship with the business.

The calculation can vary significantly depending on the business model, margin assumptions, retention period, and customer behavior.

45. Repeat Purchase Rate

Formula:
Repeat Purchase Rate = Customers With More Than One Purchase / Total Customers × 100

This is useful for understanding customer retention and purchasing behavior.

10. Executive KPIs

Executives usually don't need dozens of operational metrics on their first dashboard page. They need a concise view of business health with the ability to drill into the departments driving the result.

46. Revenue Growth

Shows whether total revenue is increasing or decreasing compared with the selected comparison period.

47. EBITDA Margin

Formula:
EBITDA Margin = EBITDA / Revenue × 100

Useful for monitoring operating profitability before interest, taxes, depreciation, and amortization.

48. Customer Acquisition Cost

CAC gives leadership a view of the cost required to generate new customers.

However, executives should not evaluate CAC alone. Pair it with customer lifetime value, retention, gross margin, and payback period where relevant.

49. Customer Lifetime Value

CLV provides a longer-term view of customer economics and can be segmented by customer type, acquisition source, product, or geography.

50. Cash Flow

Cash flow tracks the movement of cash into and out of the business.

An executive dashboard can show operating cash flow, investing cash flow, financing cash flow, and net change in cash, depending on the reporting requirement.

How to Choose the Right Power BI KPIs

Having 50 KPI ideas does not mean you should use all 50.

A common dashboard mistake is KPI overload.

Instead, ask five questions for every metric:

1. What decision does this KPI support?

If nobody takes action when the KPI changes, question whether it belongs on the dashboard.

2. Who owns the KPI?

Every important KPI should have a clear owner.

For example:

• Revenue → Sales leadership

• Gross margin → Finance/business leadership

• Time to hire → HR

• Stockout rate → Supply Chain

• First response time → Customer Service

3. What is the target?

A KPI without an appropriate benchmark can become just another number.

4. What is the comparison period?

Possible comparisons include:

• Previous day

• Previous week

• Previous month

• Previous year

• Budget

• Forecast

• Target

• Industry benchmark

5. Can users drill into the reason behind the number?

This is where Power BI becomes particularly useful.

A revenue KPI can lead to:

Revenue → Region → Salesperson → Customer → Product → Transaction

That turns a dashboard from a reporting screen into an analysis tool.

KPI vs Metric: What Is the Difference?

These terms are often used interchangeably, but they are not always the same.

A metric is a measurable value.

Examples:

• Total orders

• Website visitors

• Revenue

• Employees

• Support tickets

A KPI is a metric that is tied to a business objective or performance target.

For example:

Metric: 1,250 orders

KPI: 1,250 orders vs 1,500 monthly target = 83.3% achievement

The second provides decision-making context.

This distinction matters when designing a Power BI dashboard because not every metric needs to appear as a headline KPI.

How to Design a Power BI KPI Dashboard

A practical dashboard structure is:

Level 1: Executive Summary

Show approximately 5–7 critical KPIs.

For example:

• Revenue

• Revenue Growth

• Gross Margin

• Operating Profit

• Cash Flow

• Customer Acquisition Cost

• Customer Lifetime Value

Level 2: Department Analysis

Allow users to move into:

• Sales

• Finance

• Marketing

• HR

• Supply Chain

• Operations

• Customer Service

Level 3: Root-Cause Analysis

This is where users investigate the reason behind the KPI.

For example:

Revenue ↓

→ Which region?

→ Which product?

→ Which customer segment?

→ Which salesperson?

→ Which month?

→ Which transactions?

This approach is more valuable than placing dozens of unrelated KPI cards on a single screen.

Power BI KPI Design Tips That Improve Decision-Making

Use targets, not just current values

A KPI should answer:

Are we on track?

rather than simply:

What happened?

Show trends

A current value can hide the direction of the business.

For example:

Revenue = $500,000

is less informative than:

Revenue = $500,000
Previous month = $450,000
Target = $525,000
Growth = +11.1%
Target achievement = 95.2%

Segment important KPIs

A company-wide KPI can hide problems.

A 10% sales increase might look positive at company level while one region has declined 25%.

Use Power BI's filtering and drill-down capabilities to identify these differences.

Define every KPI

Your data model should have a clear definition for each KPI.

Document:

• Formula

• Data source

• Owner

• Frequency

• Target

• Date logic

• Filters

• Exclusions

This becomes especially important when multiple departments use the same Power BI environment.

Where Should You Start?

If you are building your first Power BI dashboard, don't start by asking:

"Which visuals should I use?"

Start with:

"Which decisions does this dashboard need to support?"

Then work backward:

Business Objective → KPI → Data → Measure → Visualization → Action

For example:

Objective: Improve sales performance

↓

KPI: Sales Target Achievement

↓

Data: Orders, targets, salespeople, products, regions

↓

Power BI Measure: Actual Sales ÷ Target Sales

↓

Visualization: KPI card + monthly trend + salesperson comparison

↓

Action: Identify territories below target and investigate the underlying causes

This approach produces a much more useful dashboard than choosing visuals first.

Final Power BI KPI Cheat Sheet

Here are the 50 KPIs again in a compact format for quick reference:

Sales

1. Revenue

2. Sales Growth Rate

3. Win Rate

4. Average Deal Size

5. Sales Target Achievement

Finance
6. Gross Profit Margin
7. Operating Expense Ratio
8. Net Profit Margin
9. Cash Conversion Cycle
10. Accounts Receivable Days

Marketing
11. Conversion Rate
12. Cost Per Lead
13. Customer Acquisition Cost
14. Return on Ad Spend
15. Marketing Qualified Leads

HR
16. Employee Turnover Rate
17. Absenteeism Rate
18. Time to Hire
19. Cost per Hire
20. Employee Retention Rate

Supply Chain
21. Inventory Turnover
22. Stockout Rate
23. Order Fulfillment Rate
24. Supplier On-Time Delivery
25. Perfect Order Rate

Operations
26. Overall Equipment Effectiveness
27. Production Yield
28. Downtime Rate
29. Cycle Time
30. Capacity Utilization

Healthcare
31. Patient Volume
32. Average Length of Stay
33. Readmission Rate
34. Average Wait Time
35. Bed Occupancy Rate

Customer Service
36. First Response Time
37. Average Resolution Time
38. First Contact Resolution
39. Customer Satisfaction Score
40. SLA Compliance Rate

Ecommerce
41. Ecommerce Conversion Rate
42. Average Order Value
43. Cart Abandonment Rate
44. Customer Lifetime Value
45. Repeat Purchase Rate

Executive
46. Revenue Growth
47. EBITDA Margin
48. Customer Acquisition Cost
49. Customer Lifetime Value
50. Cash Flow

Build Your KPI Dashboard Around the Business, Not the Visuals

The most effective Power BI dashboard is not necessarily the one with the most charts or KPI cards. It is the one that helps the right person understand what is happening, why it is happening, and what needs attention next.

DataFlip follows this business-focused approach with ready-to-use Power BI dashboards and templates across areas such as Sales, Finance, HR, Supply Chain, Marketing, Healthcare, Operations, Education, Sports, and Real Estate. The templates are designed to be customizable, including KPIs, formulas, visuals, layouts, and data sources.

If you already know the KPIs your organization needs, starting with a purpose-built Power BI template can reduce the time spent building common dashboard structures from scratch and let your team focus on connecting the model to its own data.

Need a Power BI dashboard for your department? Explore DataFlip's ready-to-use Power BI dashboard templates and customize the KPIs around your business requirements.