Manufacturing Quality Control Power BI template

Layout

Plain header, 5 outline KPIs, full-height defect Pareto beside yield trend, PPM bars + CAPA table

Page size

1280×720 px (16:9, Power BI default)

Theme

High Contrast Light

1. 1

   Unzip to a short path and open the .pbip

   Extract the zip to a short local folder such as C:\PBI (Windows limits project paths to 260 characters, and Desktop can't save a project straight to OneDrive or SharePoint), then double-click the .pbip file or use File → Open in Power BI Desktop. Microsoft still lists projects and TMDL as preview features (as of Nov 2026): if Desktop won't open the project, go to File → Options and settings → Options → Preview features, tick “Power BI Project (.pbip) save option” and “Store semantic model using TMDL format”, then restart Desktop.

2. 2

   Select Refresh once

   The project ships without the local data cache (.pbi/cache.abf), so Desktop opens the full model definition without data. Select Home → Refresh: every table is built from values written into its Power Query step, so there is no data source to sign in to.

3. 3

   Save as .pbix or connect your data

   Use File → Save as to keep a single .pbix file, or open Transform data and replace each table's Source step with your own query, keeping the column names so the measures and visuals keep working.

Units Inspected =
SUM ( Inspections[Units Inspected] )

First Pass Yield =
DIVIDE ( SUM ( Inspections[Passed First Time] ), [Units Inspected] )

Defects PPM =
DIVIDE ( SUM ( Inspections[Defective Units] ), [Units Inspected] ) * 1000000

Scrap Cost =
SUM ( Inspections[Scrap Cost] )

Defects =
SUM ( Defects[Defect Count] )

Cumulative Defect % =
VAR Current = [Defects]
VAR Total = CALCULATE ( [Defects], ALLSELECTED ( 'Defect Type' ) )
VAR Cumulative =
    SUMX (
        FILTER ( ALLSELECTED ( 'Defect Type'[Defect Type] ), CALCULATE ( [Defects] ) >= Current ),
        CALCULATE ( [Defects] )
    )
RETURN
    DIVIDE ( Cumulative, Total )

Open CAPAs =
CALCULATE ( COUNTROWS ( CAPA ), CAPA[Status] <> "Closed" )

Customer Complaints =
CALCULATE ( COUNTROWS ( CAPA ), CAPA[Source] = "Customer complaint" )

Days Open =
MAX ( CAPA[Days Open] )

• Is first pass yield improving week on week at each plant?
• Which few defect types cause most of the defects (Pareto)?
• How many defective parts per million reach final inspection?
• Which corrective actions are open or overdue, and who owns them?

• Slot: First pass yield

  KPI Card

  Executive dashboard KPI row (revenue, customers, NPS, churn)

• Slot: Defect Pareto

  Pareto Chart

  Defect category analysis (which defects cause 80% of complaints?)

1. 1

   Download the background

   Take the 1920×1080 PNG for a new page in a Fluent 2 report (the default size for new pages), or the 2× PNG (2560×1440) for sharp text on a 1280×720 Classic page. Power BI scales the image to the canvas.

2. 2

   Set the canvas background

   Format page → Canvas background → Browse. Set Image fit to Fill and transparency to 0%.

3. 3

   Import the theme

   Design ribbon → Import theme (in the Power BI service: View → Theme pane), then pick the downloaded JSON. Data colours and fonts now match the design. Older Desktop builds: View → Themes → Browse for themes.

4. 4

   Place your visuals

   Size each visual to the positions above with background and border off, or open the PBIP project where they are already placed.

• Dashboard job

  Best Power BI Visuals for Manufacturing OEE

  The best Power BI visuals for OEE — availability SPC, changeover heatmaps, downtime Pareto, loss-tree…

• Team

  Power BI for manufacturing

  OEE by line, downtime by reason and process stability: plant-floor views that read from across the room.

Want the headline numbers to look like cards rather than plain values? Browse the KPI card gallery or build your own in the SVG measure builder.

• 

  Manufacturing OEE

  Manufacturing

• 

  Maintenance & Asset Reliability

  Manufacturing

• 

  Supplier Performance Scorecard

  Supply chain