AI-First Power BI
How to add a SPC Control Chart to Power BI without writing code
Generate a Power BI SPC Control Chart without writing TypeScript. Plain-English prompt → .pbiviz file in under 5 minutes. Source code yours forever.
Power BI's marketplace has a few SPC Control Chart options, but each comes with the same trade-off: you accept the vendor's formatting opinions, pay per-seat licensing, and have no path to customise the visual without buying a higher tier or filing a feature request. The "build it yourself" alternative — write a TypeScript custom visual using D3.js and the Power BI Visuals SDK — is technically no-code at the user level but is 30-50 hours of developer time at the build level.
There's a third path most teams haven't tried yet: AI-generated custom visuals. Describe the SPC Control Chart you want — the data shape, the styling, the formatting options — and an AI generates a working .pbiviz file you import into Power BI Desktop. The result behaves like a marketplace visual (cross-filtering, tooltips, formatting pane) and costs less than a single seat of a paid marketplace visual on a one-time basis. The TypeScript source ships with the .pbiviz, so if you ever want to extend the visual yourself, you can.
Step-by-step
- 1
Describe what you want in plain English
Open VizForge. Type a description of the spc control chart — for example, the chart family, the data fields, the colour rules, the formatting options users should be able to adjust. The more specific the prompt, the closer the first generation is to what you want.
- 2
Review the AI's classification
VizForge's classifier reads your prompt and shows back the visual type and complexity it inferred. Confirm it picked the right thing (e.g. spc control chart not pie chart). If not, refine the prompt before generating.
- 3
Generate the .pbiviz
Click Generate. The pipeline runs classify → spec → code → validator → build. Total wall-clock time is typically 1-3 minutes for fresh visuals, 3-5 for refinements. You see a polling progress bar while it runs.
- 4
Refine if needed
Click Refine on the result and tell the AI what to change — "use our brand colours", "make the bars wider", "add stage-to-stage conversion labels". Each refinement is a minimal diff on the previous version, not a from-scratch regeneration.
- 5
Download and import
Download the .pbiviz. In Power BI Desktop, click the three-dot menu in the Visualizations pane → Import a visual from a file. The spc control chart appears in your gallery and behaves like any built-in chart.
- 6
Bind data and publish
Drop your fields onto the data wells. Adjust formatting in the standard Power BI formatting pane. Save the .pbix and publish to Power BI Service. The spc control chart renders identically in the browser.
The AI alternative: Generate your first spc control chart in under five minutes — free trial credits, no card required. Source code yours; refine as many times as you need.
Generate a spc control chart on VizForge →When to use a spc control chart
- 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
Frequently asked questions
Is the AI-generated .pbiviz the same quality as a marketplace visual?
Yes — it goes through the same Power BI Visuals SDK build pipeline, the same TypeScript type-checks, the same packaging. Output is a standard .pbiviz file that runs anywhere a marketplace visual runs.
What if the AI gets it wrong on the first try?
Click Refine and describe what to change. Each refinement is a small targeted diff on the working version, not a from-scratch rebuild. Most users converge in 1-3 refinements.
Do I have to pay every time I generate a visual?
Free plan: 5 credits on signup (each visual costs 1-5 credits depending on complexity). After that, credit packs are pay-as-you-go — no subscription, no per-seat licensing. Credits never expire.
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.
Fixed or rolling control limits?
Either. Rolling limits adapt as new data comes in; fixed limits freeze after a baseline period. VizForge supports both — specify in the prompt.
Can I annotate causes on violations?
Yes. Bring a Notes column and the visual shows a tooltip with your cause analysis on flagged points.
Other guides for the spc control chart
Same visual, different angle — pick the one that matches what you’re trying to do.
Reference
Data shape, DAX measures, related visuals.
Index
100 step-by-step guides across 20 Power BI visual types.
VizForge — AI-generated Power BI custom visuals.