Power BI KPI Visuals & Dashboard Cards
Enterprise guide to KPI card types, DAX calculations, conditional formatting, traffic light indicators, sparklines, and industry-specific KPI dashboard patterns.
What Are KPI Visuals in Power BI?
How do you create KPI visuals in Power BI? Power BI provides multiple KPI visual types: 1) Card visuals for single headline numbers with conditional formatting, 2) The built-in KPI visual that combines actual value, target comparison, and trend line, 3) Multi-row Cards for grouped metrics, and 4) The new Card visual (2025+) with embedded sparklines, reference labels, and sub-values. For enterprise dashboards, place 4-6 primary KPIs as conditionally-formatted Card visuals in the top row, use DAX measures for YoY/MoM calculations and target variance, and apply traffic light conditional formatting (green/amber/red) for instant status recognition. EPC Group designs KPI dashboards for Fortune 500 organizations across healthcare, finance, and government.
KPI visuals are the most important elements on any Power BI dashboard. They are the first things executives see, the metrics that drive daily decisions, and the indicators that determine whether the organization is on track. A well-designed KPI row communicates the health of the business in under 5 seconds — without requiring the viewer to interpret a chart or scan a table.
Power BI offers multiple visual types for displaying KPIs, each with different capabilities and trade-offs. The Card visual shows a single number. The KPI visual adds target comparison and trend context. The Multi-row Card displays multiple metrics compactly. The new Card visual (2025+) combines all of these capabilities — sparklines, reference labels, multiple values, and conditional formatting — into a single, modern visual. Choosing the right visual type for each metric is a design decision that directly affects dashboard usability.
This guide covers every aspect of Power BI KPI visualization — from basic Card setup to advanced DAX calculations, conditional formatting patterns, and industry-specific KPI frameworks. EPC Group's Power BI consulting practice has designed KPI dashboards for organizations ranging from 50-user departments to 10,000+ user enterprise deployments.
Power BI KPI Visual Types Compared
Power BI offers five visual types for KPI display. Each serves a different purpose — understanding when to use each is essential for effective dashboard design.
Card Visual
Displays a single headline number — the most common KPI visual in Power BI. Shows the current value of a measure with optional data label formatting and conditional formatting for font/background color. Best for clean, single-metric KPI displays at the top of executive dashboards.
KPI Visual
The only Power BI visual that combines actual value, target comparison, and trend line in a single visual. Shows red/green/amber status automatically based on target attainment. Requires a date field for the trend axis.
Multi-Row Card
Displays multiple measures in a compact card grid layout. Each measure gets its own labeled row within the card. Useful for showing a group of related KPIs without consuming multiple visual slots on the dashboard canvas.
New Card Visual (2025+)
The next-generation Power BI card that supports multiple callout values, reference labels, sparklines, images, and sub-values within a single visual. Dramatically reduces the number of visuals needed for KPI rows on dashboards.
Gauge
Displays a single value against a target on a half-circle dial. Shows minimum, maximum, and target bands. Visually striking but consumes significant canvas space for a single metric. Best used sparingly for the single most important KPI.
The Built-In KPI Visual: Setup and Configuration
The built-in KPI visual is the only Power BI visual that natively combines actual value, target, and trend in a single visualization. It is designed specifically for key performance indicators and includes automatic status coloring — green when actual meets or exceeds target, red when below target.
To configure the KPI visual: add your actual-value measure to the Indicator field (e.g., Total Revenue), add a date field to the Trend axis (e.g., Month), and add your target measure to the Target goals field (e.g., Revenue Target). The visual displays the current value prominently, a mini trend chart below, and a red/green status indicator based on target attainment. Direction settings control whether higher or lower values are "good" — essential for metrics like cost or defect rate where lower is better.
The KPI visual has limitations: it requires a date-type trend axis (it cannot show categorical trends), formatting options are more restricted than Card visuals, and it occupies more vertical space than a simple Card. For these reasons, EPC Group typically reserves the KPI visual for 1-2 key metrics where the trend and target context are critical, and uses Card visuals with conditional formatting for the remaining KPI row metrics.
Indicator
The actual-value measure — this is the headline number displayed prominently. Use a pre-formatted DAX measure (e.g., Total Revenue = SUM(Sales[Revenue])) rather than a raw column.
Trend Axis
A date field that defines the x-axis of the mini trend chart. The KPI visual renders a sparkline-style trend. Must be a Date/DateTime type — text or numeric fields will not render correctly.
Target Goals
The target measure against which the Indicator is compared. Can be a fixed number, a DAX measure (e.g., Budget Target), or a column-based value. Drives the red/green status indicator.
Essential DAX Measures for KPI Calculations
Raw numbers alone do not make effective KPIs. An executive does not just want to know that revenue is $4.2M — they want to know if that is above or below target, whether it grew compared to last year, and what the trend looks like. DAX measures transform raw values into contextual KPI metrics that drive action.
The following DAX patterns are the foundation of every enterprise KPI dashboard EPC Group deploys. Each measure produces a numeric value that can be displayed in a Card visual and drive conditional formatting rules for status coloring.
Year-over-Year Growth
Shows annual growth trajectory. Format as percentage. Apply conditional formatting: green if positive, red if negative.
Month-over-Month Change
Shows monthly momentum. Critical for detecting trends before they compound. Use in combination with YoY to distinguish seasonal patterns from true changes.
Target Variance
Shows how far actual performance is from plan. The most direct KPI for accountability. Apply diverging conditional formatting: green ≥0%, amber ≥-10%, red <-10%.
Year-to-Date Running Total
Cumulative year-to-date total that resets each January. Essential for tracking annual targets. Compare against a prorated annual target for monthly accountability.
3-Month Moving Average
Smooths monthly volatility to reveal underlying trends. Better than raw monthly values for executive-level trend KPIs where seasonal spikes distort the picture.
KPI Status Color (for conditional formatting)
Returns a hex color code based on target attainment. Use as the "Field value" in conditional formatting rules for font or background color. Ensures consistent color across all KPI cards.
Conditional Formatting and Traffic Light KPI Indicators
Conditional formatting transforms KPI numbers into instant status signals. An executive glancing at a dashboard should understand the health of every KPI without reading a single number — green means on track, amber means attention needed, red means action required. This requires systematic conditional formatting applied consistently across all KPI visuals.
Power BI supports conditional formatting on font color, background color, icons, data bars, and web URLs for Card, Multi-row Card, and the new Card visual. For KPI status indicators, font color and background color are the most effective — they provide the strongest visual signal while maintaining readability.
The traffic light pattern (red-amber-green or RAG) is the most universally understood status indicator in enterprise reporting. Implementation requires: 1) a DAX measure that calculates the status threshold (e.g., target variance percentage), 2) conditional formatting rules that map value ranges to colors, and 3) accessibility considerations — always add text labels or icons alongside colors because 8% of males cannot distinguish red from green.
| Status | Condition | Hex Color | Use Case | Accessible Alternative |
|---|---|---|---|---|
| Green (On Track) | Actual >= Target | #22C55E | KPI is meeting or exceeding the defined target | Checkmark icon + "On Track" label |
| Amber (At Risk) | Actual >= 80% of Target | #F59E0B | KPI is within 20% of target — attention needed | Warning icon + "At Risk" label |
| Red (Off Track) | Actual < 80% of Target | #EF4444 | KPI is significantly below target — action required | X icon + "Off Track" label |
| Blue (Informational) | No target defined | #3B82F6 | Informational KPIs without targets (e.g., total volume) | Info icon + trend direction |
| Gray (No Data) | BLANK() or NULL | #9CA3AF | Data not available for the selected period | "N/A" or "No Data" label |
Sparklines in KPI Cards
A KPI number without trend context is incomplete. Executives need to know not just that revenue is $4.2M, but whether it is trending up, flat, or declining. Sparklines — tiny inline charts — provide this trend context within the KPI card itself, eliminating the need for a separate trend chart that consumes dashboard real estate.
The new Card visual (2025+) supports native sparklines. Add a date field and measure to the sparkline configuration, and Power BI renders a mini line chart directly within the card. This is the recommended approach for 2026 enterprise dashboards — it produces clean results, respects card-level filters, and requires no workarounds.
For organizations still using legacy Card visuals, sparklines can be simulated by positioning a minimally-formatted Line chart (no axes, no grid, no legend) adjacent to the Card visual. This approach requires careful alignment and responsive layout management. EPC Group is actively migrating enterprise dashboards from this workaround pattern to the native new Card visual sparklines.
New Card Sparkline
Native sparkline within the new Card visual. Add a date field and measure to the sparkline well. Configure line color, area fill, and point markers. Respects all card-level filters and slicers.
Adjacent Line Chart
Position a small, minimally-formatted Line chart next to a Card visual. Remove axes, gridlines, legend, and title. Match the card height. Labor-intensive but works with all Power BI versions.
SVG Image Sparkline
Advanced technique: a DAX measure generates SVG markup that renders as an inline image. Provides full control over sparkline appearance but requires complex DAX and maintenance overhead.
Industry KPI Examples for Power BI Dashboards
These KPI frameworks represent production patterns EPC Group deploys across regulated industries. Each includes the recommended visual type and conditional formatting approach.
Sales KPIs
Revenue (Actual vs Target)
Visual: New Card + sparkline
Format: RAG vs annual target
Win Rate
Visual: Card with conditional formatting
Format: Green ≥40%, Amber ≥30%, Red <30%
Average Deal Size
Visual: Card with MoM reference label
Format: Blue informational with trend arrow
Pipeline Velocity
Visual: KPI visual with monthly trend
Format: RAG vs pipeline target
Customer Acquisition Cost
Visual: Card with YoY comparison
Format: Green if decreasing, Red if increasing
Operations KPIs
OEE (Overall Equipment Effectiveness)
Visual: Gauge + Card
Format: Green ≥85%, Amber ≥70%, Red <70%
On-Time Delivery Rate
Visual: Card with conditional formatting
Format: Green ≥95%, Amber ≥90%, Red <90%
Cycle Time
Visual: KPI visual with weekly trend
Format: Green if decreasing, Red if increasing
Inventory Turns
Visual: Card with YoY reference
Format: Green if increasing, Amber if flat
Capacity Utilization
Visual: New Card + sparkline
Format: Amber >90% (over-capacity risk)
Finance KPIs
Gross Margin %
Visual: Card with target variance
Format: RAG vs budget target
Operating Margin %
Visual: Card with MoM trend
Format: RAG vs prior year
DSO (Days Sales Outstanding)
Visual: KPI visual with monthly trend
Format: Green ≤30, Amber ≤45, Red >45
Working Capital Ratio
Visual: Card with conditional formatting
Format: Green ≥1.5, Amber ≥1.0, Red <1.0
EBITDA
Visual: New Card + YTD sparkline
Format: RAG vs annual budget
Healthcare KPIs
Patient Volume
Visual: New Card + daily sparkline
Format: Blue informational with capacity threshold
Average Length of Stay
Visual: KPI visual with weekly trend
Format: Green if decreasing toward benchmark
Readmission Rate (30-day)
Visual: Card with conditional formatting
Format: Green <15%, Amber <20%, Red ≥20%
Bed Occupancy Rate
Visual: Card with threshold coloring
Format: Amber >85% (staff strain), Red >95%
Patient Satisfaction (HCAHPS)
Visual: Card with quarterly trend
Format: RAG vs national benchmark
KPI Dashboard Best Practices
Every KPI Must Drive Action
Ask: "If this number changes, does someone take action?" If the answer is no, remove the KPI. Dashboard real estate is precious — vanity metrics waste it. A KPI that does not drive a decision is just a number.
Show Comparison Context
A number without context is meaningless. Every KPI should show at least one comparison: vs target, vs prior period, or vs benchmark. "Revenue: $4.2M" means nothing. "Revenue: $4.2M (+12% YoY, 3% above target)" drives decisions.
Consistent Color Language
Green means on track. Amber means attention needed. Red means action required. Never deviate across the dashboard. If "red" means "bad" on one card and "high volume" on another, you have broken the visual language.
Limit to 4-6 Top-Row KPIs
The human brain cannot process more than 6 items simultaneously. Place 4-6 primary KPIs in the top row. Group secondary metrics in a Multi-row Card or drill-through page. The top row is the executive summary — keep it focused.
Design for Mobile
KPI cards must render cleanly on phone screens. Use the phone layout editor to stack cards vertically. Ensure font sizes remain readable on small screens. Many executives check dashboards on mobile first thing in the morning.
Standardize Metric Definitions
If Sales says "Revenue is $4.2M" and Finance says "$3.9M," the dashboard has failed. Define each KPI in a shared dataset with a documented calculation methodology. One source of truth, one definition, one number.
Related Resources
Power BI Consulting Services
Enterprise Power BI implementation, KPI dashboard design, governance, and managed analytics from EPC Group.
Read morePower BI Dashboard Design Best Practices
Complete guide to enterprise dashboard layout, visual hierarchy, accessibility, drill-through, and governance.
Read moreEnterprise Analytics Solutions
Full-stack enterprise analytics on the Microsoft platform — Power BI, Fabric, Purview, and Copilot.
Read moreFrequently Asked Questions
How do you create KPI visuals in Power BI?
Power BI offers multiple ways to create KPI visuals: 1) The built-in KPI visual — add an Indicator (actual value), Trend axis (date field), and Target goal to display value, trend, and target attainment in one visual, 2) Card visuals — display a single headline number with optional conditional formatting for color-coded status, 3) Multi-row Card — show multiple KPIs in a compact card layout, 4) The new Card visual (2025+) — supports reference labels, sparklines, and images within a single card. For enterprise dashboards, EPC Group typically uses a combination: Card visuals with conditional formatting for the top KPI row, and the KPI visual for metrics that need trend context.
What is the difference between a Card visual and a KPI visual in Power BI?
A Card visual displays a single number — it shows the current value of a measure with optional data label formatting. A KPI visual displays three pieces of information simultaneously: the actual value (Indicator), the target value (Target goal), and a trend line (Trend axis). The KPI visual also shows a red/green/amber status indicator based on whether the actual value meets the target. Use Card visuals when you want clean headline numbers (revenue, customer count, margin percentage). Use KPI visuals when the target comparison and trend direction are essential context for the metric.
How do you add conditional formatting to KPI cards in Power BI?
To add conditional formatting to Card or Multi-row Card visuals: 1) Select the visual, 2) In the Format pane, expand "Callout value" (Card) or the relevant field section, 3) Click the fx button next to the font color property, 4) Set rules — e.g., if value >= target then green, if value >= 80% of target then amber, else red. For background color conditional formatting, use the same approach on the card background property. For the new Card visual, conditional formatting applies to reference labels, enabling traffic light indicators directly within the card. EPC Group creates DAX measures that return specific color hex codes (e.g., "#22C55E" for green) and uses these in conditional formatting rules for consistent enterprise theming.
What DAX measures should I use for KPI calculations?
The most common KPI DAX patterns are: 1) Year-over-Year growth: DIVIDE([Current Year] - [Prior Year], [Prior Year]) using CALCULATE with SAMEPERIODLASTYEAR, 2) Month-over-Month: DIVIDE([Current Month] - CALCULATE([Measure], DATEADD(Calendar[Date], -1, MONTH)), CALCULATE([Measure], DATEADD(Calendar[Date], -1, MONTH))), 3) Target variance: DIVIDE([Actual] - [Target], [Target]), 4) Running total: CALCULATE([Measure], DATESYTD(Calendar[Date])), 5) Moving average: AVERAGEX(DATESINPERIOD(Calendar[Date], MAX(Calendar[Date]), -3, MONTH), [Measure]). Each measure should be formatted with appropriate number format and combined with conditional formatting to create status-aware KPI cards.
How do you create traffic light KPI indicators in Power BI?
Traffic light (red-amber-green) KPI indicators require a DAX measure that returns a status value and conditional formatting that maps statuses to colors. Create a DAX measure like: KPI Status = SWITCH(TRUE(), [Actual] >= [Target], "Green", [Actual] >= [Target] * 0.8, "Amber", "Red"). Then apply conditional formatting: use rules-based formatting on the card font color or background color, mapping "Green" to #22C55E, "Amber" to #F59E0B, and "Red" to #EF4444. For icon-based traffic lights, use the KPI visual built-in status indicator or create a measure that returns Unicode circle characters (green circle, yellow circle, red circle) displayed in a card. Always add text labels alongside colors for WCAG 2.1 AA accessibility compliance.
What is the new Card visual in Power BI and how is it different?
The new Card visual (available in Power BI Desktop 2025+) replaces the legacy Card and Multi-row Card with a significantly more capable single visual. Key improvements: 1) Multiple callout values in one card — no need for separate cards per KPI, 2) Reference labels — add context like "vs Target" or "vs Prior Year" directly in the card, 3) Sparklines — embed trend mini-charts inside the card without a separate line chart, 4) Images — include icons or logos within the card, 5) Sub-values — show secondary metrics below the headline number. The new Card visual enables enterprise KPI cards that previously required complex workarounds or third-party visuals. EPC Group is migrating enterprise dashboards to the new Card visual for improved information density and reduced visual count.
How many KPIs should be on an executive dashboard?
Executive dashboards should display 4-6 KPIs maximum in the top row. Each KPI must answer the question: "If this number changes, does someone take action?" If the answer is no, remove it. The recommended layout: 3-4 primary KPIs as large Card visuals across the top, with 1-2 supporting KPIs as smaller secondary cards. Every KPI should show: current value, comparison (vs target, vs prior period, or vs benchmark), trend direction (sparkline or arrow), and status color (conditional formatting). EPC Group executive dashboards follow the SMART KPI framework: Specific, Measurable, Actionable, Relevant, Time-bound. Vanity metrics that look impressive but do not drive decisions are removed during dashboard design reviews.
How do you add sparklines to KPI cards in Power BI?
Sparklines in Power BI KPI cards can be added through several methods: 1) The new Card visual (2025+) supports native sparklines — add a date field and measure to the sparkline well, 2) For legacy visuals, create a small Line chart visual with minimal formatting (no axes, no grid lines, no legend) and position it adjacent to or overlapping a Card visual, 3) Use the "Image" conditional formatting option with a DAX measure that generates sparkline SVG strings (advanced technique). The new Card visual sparklines are the recommended approach for 2026 — they render natively, respect card-level filters, and eliminate the need for visual layering workarounds. EPC Group embeds sparklines in executive KPI rows to show 12-month trend context alongside headline numbers.
What are the best KPIs for different industries in Power BI?
Industry-specific KPIs that EPC Group implements most frequently: Sales — revenue (actual vs target), win rate, average deal size, pipeline velocity, customer acquisition cost. Operations — OEE (Overall Equipment Effectiveness), cycle time, on-time delivery, inventory turns, capacity utilization. Finance — gross margin, operating margin, DSO (Days Sales Outstanding), working capital ratio, EBITDA. HR — turnover rate, time-to-hire, employee engagement score, training completion rate, headcount vs plan. Healthcare — patient volume, average length of stay, readmission rate, bed occupancy, patient satisfaction (HCAHPS). Each KPI should include target comparison, trend direction, and conditional formatting in the Power BI implementation.
Need Enterprise KPI Dashboard Design?
EPC Group designs production-grade Power BI KPI dashboards with proper DAX calculations, conditional formatting, traffic light indicators, sparklines, and governance — built for the metrics that drive your business decisions.