Power BI Custom Visual

SPC Control Chart for Power BI

AI-generated spc control chart for Power BI. Describe what you need in plain English; download a ready-to-import .pbiviz file. Full TypeScript source included.

A statistical process control (SPC) chart tracks a process output over time with a mean line, upper and lower control limits (UCL/LCL), and often 1- and 2-sigma bands. Operations, manufacturing, healthcare, and reliability engineering teams use SPC to distinguish routine variation from meaningful shifts that require investigation.

Power BI has nothing native for SPC. Marketplace options exist but typically implement only the basic Shewhart chart without Western Electric rule annotations (the "8 rules" that flag out-of-control patterns like runs, trends, and oscillations).

VizForge generates a Power BI SPC control chart with the rule set you specify. Our AI writes the TypeScript visual to compute mean and control limits from your data window, overlay sigma bands, annotate rule violations with visual flags, and package it as a .pbiviz. You own the rule logic and can edit which ones to enable.

When to use a spc control chart in Power BI

Manufacturing yield and defect-rate monitoring
Healthcare quality metrics (readmission rate, infection rate)
Call-center AHT (average handle time) tracking
Web service SLA tracking with process-shift detection
Financial reconciliation variance monitoring

Example prompt

Example VizForge prompt

SPC control chart (X-bar, individuals). Plot daily defect count with mean, 3-sigma UCL and LCL, 1-sigma and 2-sigma bands in lighter shading. Flag points outside UCL in red; annotate runs of 7+ consecutive points on one side of the mean.

Data shape required

Two columns: Date (date) and Value (numeric). Window for mean and sigma calculation either fixed (first N points) or rolling — specify in the prompt.

Typical DAX measures

Mean = AVERAGE( Process[Value] )

Sigma = STDEV.P( Process[Value] )

UCL = [Mean] + 3 * [Sigma]
LCL = [Mean] - 3 * [Sigma]

Out Of Control =
    VAR V = SUM( Process[Value] )
    RETURN IF( V > [UCL] || V < [LCL], 1, 0 )

Generate a SPC Control Chart — starts free

Free plan: 3 visuals per month. No credit card required.

FAQ

Which control-chart types are supported?

Individuals (I-chart), X-bar (with subgroup size), moving range (MR), p-chart (proportion defective), and c-chart (count). Prompt for the type you need.

Which Western Electric rules?

All 8 standard rules (point beyond 3σ, 2-of-3 beyond 2σ, 4-of-5 beyond 1σ, 8 on one side, 6 trending, 14 alternating, 15 within 1σ, 8 outside 1σ). Prompt to toggle specific ones.