Component values and references in PCB Design - Dashboard Guide

Dashboard Mode - Component values and references

Dashboard Goal

Understand the distribution of component values and their reference designators on a PCB to help with inventory and assembly planning.

Sample Data

Reference	Component Type	Value	Quantity
R1	Resistor	10kΩ	1
R2	Resistor	10kΩ	1
C1	Capacitor	100nF	1
C2	Capacitor	10uF	1
U1	IC	ATmega328	1
L1	Inductor	10uH	1
R3	Resistor	1kΩ	1

Dashboard Components

• KPI Card: Total Components
  Formula: COUNTROWS(Data)
  Result: 7
• KPI Card: Total Resistors
  Formula: CALCULATE(COUNTROWS(Data), Data[Component Type] = "Resistor")
  Result: 3
• Bar Chart: Quantity by Component Type
  X-axis: Component Type
  Y-axis: SUM(Quantity)
  Shows total quantity per component type
• Table: Components with Values
  Columns: Reference, Component Type, Value, Quantity
  Shows detailed list of components

Dashboard Layout

+----------------------+----------------------+
| Total Components (7) | Total Resistors (3)  |
+----------------------+----------------------+
|                      Bar Chart: Quantity by Component Type           |
|                      (Resistor, Capacitor, IC, Inductor)            |
+---------------------------------------------------------------------+
|                          Table: Components with Values              |
+---------------------------------------------------------------------+

Interactivity

A filter by Component Type allows users to select one or multiple types. When applied, the KPI cards, bar chart, and table update to show data only for the selected component types.

Self Check

If you add a filter for Component Type = Capacitor, which components update?

• KPI Cards update: Total Components shows 2, Total Resistors shows 0
• Bar Chart updates to show only Capacitor quantity (2)
• Table shows only Capacitor rows (C1 and C2)

Key Result

Dashboard shows total components, resistor count, quantity by type, and detailed component list with filtering by component type.