Power BI KPI Visuals & Dashboard Cards Guide 2026

Microsoft Power BI KPI Visuals & Dashboard Guide (2026)

Microsoft Power BI KPI visuals display key performance indicators with target comparisons, period-over-period analysis, and conditional formatting. EPC Group enterprise clients deploy KPI visuals across executive dashboards, operational reports, and Microsoft 365 Copilot grounding scenarios.

EPC Group has delivered Microsoft Power BI KPI dashboards since the original Microsoft Power BI beta program (Project Crescent, 2010-2013).

TL;DR — Microsoft Power BI KPI Visualization Options

Microsoft Power BI Card Visual

Use Cases

• Executive headline KPIs
• Single-value display
• Period-over-period change

Microsoft Power BI Multi-row Card

Use Cases

• Top 3-5 KPIs side-by-side
• Department-specific KPIs
• Mobile-responsive layouts

Microsoft Power BI KPI Visual

Capabilities

• Indicator value
• Target value
• Trend indicator (up / down)
• Conditional color (good / bad)

Use Cases

• Sales vs target
• HEDIS measure compliance vs target
• OEE vs target
• FINRA Rule 3110 supervisory KPIs

Microsoft Power BI Gauge

Use Cases

• Min / max ranges
• Goal completion
• Quality score

DAX KPI Patterns

Status Color DAX

KPI Status Color =
SWITCH(TRUE(),
    [Sales] >= [Target] * 1.0, "#28A745",
    [Sales] >= [Target] * 0.8, "#FFC107",
    "#DC3545"
)

Period-Over-Period Comparison

Sales YoY Growth = DIVIDE([Sales] - [Sales Prior Year], [Sales Prior Year])

YoY Status =
SWITCH(TRUE(),
    [Sales YoY Growth] >= 0.20, "Excellent",
    [Sales YoY Growth] >= 0.05, "Healthy",
    [Sales YoY Growth] >= 0, "Flat",
    "Declining"
)

Industry-Specific KPI Patterns

Healthcare KPIs

• HEDIS measure compliance
• CMS Star Ratings
• Patient satisfaction (HCAHPS)
• Joint Commission audit indicators
• Readmission rates

Financial Services KPIs

• Trading P&L
• VaR (Value at Risk)
• Sharpe ratio
• FINRA Rule 3110 supervisory metrics
• SEC Rule 17a-4 retention status

Manufacturing KPIs

• OEE (Overall Equipment Effectiveness)
• First-pass yield
• Defect rate (PPM)
• Equipment downtime
• Microsoft Defender for IoT alerts

Pharma KPIs

• Clinical trial enrollment
• Regulatory submission status
• Adverse event frequency
• 21 CFR Part 11 audit trail integrity

Government KPIs

• Mission readiness
• Budget vs actual
• Compliance posture (FedRAMP, CMMC)
• DoD metrics

Microsoft Power BI Card + Microsoft 365 Copilot

Microsoft 365 Copilot Chat KPI Q&A

• "What's our current sales vs target?"
• "Show me HEDIS compliance status"
• "What's our OEE this week?"
• Microsoft 365 Copilot grounds on Microsoft Power BI semantic models

Microsoft Power BI Copilot KPI Generation

• Microsoft Power BI Copilot generates KPI visuals from natural language
• Microsoft Power BI Copilot prompt engineering

EPC Group Microsoft Power BI KPI Engagement

EPC Group fixed-fee Microsoft Power BI KPI:

• Single dashboard with KPIs: $20K-$60K (2-4 weeks)
• Multi-dashboard KPI suite: $60K-$200K (4-8 weeks)
• Enterprise KPI Microsoft Power BI Apps: $200K-$700K (3-6 months)

Frequently Asked Questions

Card vs KPI visual?

Card for single value. KPI visual for indicator + target + trend.

What about Microsoft Power BI Copilot?

Microsoft Power BI Copilot can generate KPI visuals from natural language. F64+ Microsoft Fabric capacity required.

Who delivers EPC Group Microsoft Power BI KPI engagements?

Errin O'Connor (CEO, 4-time Microsoft Press author including Power BI book, Project Crescent original beta team) leads.

Next Steps

Schedule a 30-minute Microsoft Power BI KPI discovery call at /schedule or call (888) 381-9725.

Related reading: Power BI Dashboard Design Best Practices Enterprise, Power BI Conditional Formatting Enterprise Guide, Power BI Semantic Model Enterprise Guide, Power BI DAX Formulas Enterprise Reference Guide, and Power BI Center of Excellence Enterprise Playbook.