# SmartVisuals Waffle & Pictogram for Power BI

> Waffle, dot matrix, pictogram, icon array and parliament charts for Power BI that always add up to 100. Icons and targets free; premium survey margins and seat change.

- Page: https://www.smartvisuals.io/visuals/waffle-pictogram
- Fields and settings: https://www.smartvisuals.io/visuals/waffle-pictogram/settings
- Microsoft Marketplace: https://marketplace.microsoft.com/en-us/product/smartvisuals.smartvisuals-waffle-pictogram?tab=overview
- Package: https://www.smartvisuals.io/downloads/smartvisuals-waffle-pictogram-1.0.0.0.pbiviz
- Price: Free tier for every viewer; premium $1.99 per user per month or $19 per user per year on Microsoft Marketplace, with a 30-day free trial. Premium works in edit mode without a licence; unlicensed viewers see the free tier, never a blocked visual.
- Certified by Microsoft: no
- Version: 1.0.0.0
- GUID (visualType and publicCustomVisuals): `smartvisualsWafflePictogram5CC147332D0C4345D7CA117FC6ACBDF9`

## What is free

- **Grids that add up**: Percent grids of any rows and columns allotted by largest remainder, so they always make exactly 100; unit grids (1 cell = N); fill direction; one grid or one per category.
- **Icons, free**: A built-in set, an icon per category in the format pane, a custom icon as an SVG path or a data:image URI, or an Icon field. Web addresses are ignored.
- **Pictogram layouts**: Isotype rows with the last icon cut to the exact value, an icon array, and an infographic card that fills one icon to the share or reads "1 in 4".
- **Parliament**: Seats on a semicircle, arch or full circle, with a majority line: simple, two thirds, three fifths or a typed quota.
- **A target, free**: One goal per category, the target cell marked, over, on or under, with status colours.
- **Fill-in and spotlight**: Cells and icons fill in order when the data changes (off with reduced motion), and hovering a category dims the rest.
- **Headline, labels and caption**: A headline number, labels, a legend, a smart caption ("Likely is the largest share at 37 %") and a methods footnote.
- **Power BI features**: Tooltips and report page tooltips, highlight and cross-filter, Ctrl to add, bookmarks, context menu, drilldown and a show condition.
- **Templates, themes and on-object formatting**: Six templates (Infographic among them), four themes, four fonts, colour rules, fx colours, patterns, transparent background and formatting on the canvas.
- **Accessibility and 20 languages**: One tab stop with arrow keys, a screen-reader live region, an accessible data table, high contrast with fill patterns and a responsive layout for small tiles.

## What premium adds

- **Gained and lost cells**: Against last period or plan, on the same grid, with the shift in points and units.
- **Survey margins of error**: On the Kish effective base with design weights, drawn as a band of cells, Wilson or normal, at 90, 95 or 99 %.
- **Wave significance**: A two-proportion z-test against the last wave, on its own base when you bind Compare base.
- **Sample-size planner**: The respondents the next wave needs to read every share to ± X points, with the design effect of your weights.
- **Seat change**: Each list's seats against the previous composition, with the old composition as an outer ring.
- **Coalition builder**: The coalitions that reach a majority, smallest first, or the seats of the parties you pick.
- **Small multiples and findings**: One panel per value of a Small multiples field, and up to five findings with "how calculated".

## Fields

| Field | Internal name | Takes | Needed | What it is for |
| --- | --- | --- | --- | --- |
| Category | `category` | Column | Optional | The parts: slices, petals, rings, cells, icons, stages or columns |
| Segment | `segment` | Column | Optional | A second split: an outer ring, stacked petals or stages, Marimekko rows, waffle colours |
| Values | `values` | Measure | Optional | The size of each part |
| Compare | `compare` | Measure | Optional | Last period, plan or any reference: share shift, ghost marks, findings (premium) |
| Target | `target` | Measure | Optional | A goal per part |
| Sample size | `sampleSize` | Measure | Optional | Respondents behind each share: margin of error (premium) |
| Effective base | `effectiveBase` | Measure | Optional | Kish effective base of weighted data, (Σw)² / Σw² (premium) |
| Icon | `icon` | Measure | Optional | Built-in icon name, SVG path or data:image URI per part |
| Annotation | `annotation` | Measure | Optional | Text measure: a callout on the part |
| Small multiples | `facet` | Column | Optional | One chart per value |
| Tooltips | `tooltips` | Measure | Optional | Extra fields in tooltips |
| Show condition | `showCondition` | Measure | Optional | A measure returning 1 / TRUE to show the chart, 0 / FALSE / blank to show a message instead |
| Compare base | `compareBase` | Measure | Optional | Effective base (or sample size) of the Compare wave: the wave test uses it instead of the current base (premium) |

## Format pane

Each card is a key under `visual.objects` in a PBIR visual.json; each setting is a property of it. Toggles take `true`/`false`, choices and text a value in single quotes (`'auto'`), numbers a `D` suffix (`12D`).

### View (`view`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Chart | `type` | `waffle` (Waffle), `pictogram` (Pictogram) |

### Templates (`templates`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Style Template | `preset` | `none` (None (style defaults)), `executive` (Executive), `ibcs` (IBCS (Finance)), `minimal` (Minimal), `presentation` (Presentation), `print` (Print), `infographic` (Infographic), `custom` (Custom) |
| Applied | `applied` | Text |

### Waffle (`waffle`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Grid | `grid` | `percent` (Percent grid (each cell = 1 %)), `unit` (Unit grid (each cell = N units)) |
| Rows | `rows` | Number |
| Columns | `columns` | Number |
| Units per Cell (0 = auto) | `unitValue` | Number |
| Layout | `layout` | `stacked` (One grid, all categories), `perCategory` (One grid per category) |
| Fill Direction | `fill` | `row` (Row by row), `column` (Column by column), `snake` (Snake) |
| Cell Shape | `cellShape` | `theme` (From theme), `square` (Square), `rounded` (Rounded square), `circle` (Circle (dot matrix)), `icon` (Icon) |
| Icon | `icon` | `person` (Person), `people` (People), `woman` (Woman), `man` (Man), `building` (Building), `factory` (Factory), `house` (House), `box` (Box), `truck` (Truck), `car` (Car), `cart` (Shopping cart), `dollar` (Dollar), `euro` (Euro), `coin` (Coin), `heart` (Heart), `star` (Star), `leaf` (Leaf), `drop` (Water Drop), `bolt` (Bolt), `laptop` (Laptop), `phone` (Phone), `seat` (Seat), `check` (Check mark), `circle` (Circle), `square` (Square) |
| Custom Icon (SVG path or data:image) | `customIcon` | Text |
| Cell Gap (%) | `gap` | Number |
| Headline Number | `headline` | On / off |
| Headline Shows | `headlineFocus` | `largest` (The largest category), `first` (The first category) |
| Empty Cell Colour | `emptyColor` | Colour |
| Show “1 cell = N” Under the Grid | `unitNote` | On / off |
| Show “% of Target” in the Labels | `targetText` | On / off |
| Fill-In Animation | `fillIn` | On / off |
| Hover Spotlight | `spotlight` | On / off |

### Pictogram (`pictogram`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Layout | `mode` | `isotype` (Isotype rows (one row per category)), `array` (Icon array (one block)), `parliament` (Parliament (hemicycle)), `card` (Infographic card (one icon filled to %)) |
| Icon | `icon` | `person` (Person), `people` (People), `woman` (Woman), `man` (Man), `building` (Building), `factory` (Factory), `house` (House), `box` (Box), `truck` (Truck), `car` (Car), `cart` (Shopping cart), `dollar` (Dollar), `euro` (Euro), `coin` (Coin), `heart` (Heart), `star` (Star), `leaf` (Leaf), `drop` (Water Drop), `bolt` (Bolt), `laptop` (Laptop), `phone` (Phone), `seat` (Seat), `check` (Check mark), `circle` (Circle), `square` (Square) |
| Custom Icon (SVG path or data:image) | `customIcon` | Text |
| Units per Icon (0 = auto) | `unitValue` | Number |
| Icons per Row (0 = auto) | `perRow` | Number |
| Parliament Shape | `span` | `semicircle` (Semicircle), `arch` (Arch (240°)), `full` (Full circle) |
| Majority | `majority` | `simple` (Simple majority (> 50 %)), `twoThirds` (Two thirds), `threeFifths` (Three fifths), `quota` (Typed quota), `none` (None) |
| Seats Needed | `quota` | Number |
| Card Reads | `cardStyle` | `share` (Share (e.g. 34 %)), `oneIn` (One in N), `progress` (Progress to target) |
| Empty Icon Colour | `emptyColor` | Colour |
| Seat Total in the Centre | `readout` | On / off |
| Card Caption | `cardCaption` | On / off |
| Fill-In Animation | `fillIn` | On / off |
| Hover Spotlight | `spotlight` | On / off |

### Sorting and Other (`sorting`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Sort | `sort` | `desc` (Largest first), `asc` (Smallest first), `name` (Name), `data` (Data order), `order` (Stage order field) |
| Readers Can Change the Sort | `readerSort` | On / off |
| Group Small Items Into Other | `other` | On / off |
| Show at Most (items) | `maxItems` | Number |
| Group Items Below (%) | `minShare` | Number |
| Other Label | `otherLabel` | Text |

### Data Labels (`labels`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show | `show` | On / off |
| Content | `content` | `category` (Category), `value` (Value), `percent` (Percent of total), `categoryPercent` (Category, percent), `categoryValue` (Category, value), `valuePercent` (Value, percent), `all` (Category, value, percent) |
| Position | `position` | `auto` (Auto), `inside` (Inside), `outside` (Outside with leader lines) |
| Percent Decimals | `percentDecimals` | Number |
| Display Units | `displayUnits` | `auto` (Auto), `none` (None), `K` (Thousands), `M` (Millions), `B` (Billions) |
| Value Decimals (-1 = auto) | `valueDecimals` | Number |
| Hide Labels Below (%) | `hideBelow` | Number |
| Font Size | `fontSize` | Number |
| Text Colour | `color` | Colour |
| Detail Text Size | `detailSize` | Number |
| Detail Text Colour | `detailColor` | Colour |

### Legend (`legend`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show | `show` | On / off |
| Position | `position` | `auto` (Auto (only when labels do not name the items)), `top` (Top), `bottom` (Bottom), `right` (Right), `left` (Left) |
| Font Size | `fontSize` | Number |
| Text Colour | `color` | Colour |

### Colour Rules (`colorRules`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Rule | `mode` | `none` (None (one colour per item)), `rank` (Highlight the top N), `value` (Above / below a value), `share` (Above / below a share (%)) |
| Top N | `topN` | Number |
| Threshold | `threshold` | Number |
| Highlight / Above Colour | `highColor` | Colour |
| Others / Below Colour | `lowColor` | Colour |

### Compare (`compare`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show the Comparison | `show` | On / off |
| Comparison Name | `name` | Text |
| Change Labels | `labels` | `pp` (Share shift (pp)), `value` (Value change), `percent` (% change), `none` (None) |
| Draw the Comparison (ghost) | `ghost` | On / off |
| Sort by Change | `sortByChange` | On / off |
| Volume vs Mix Split | `volumeMix` | On / off |
| Concentration (HHI, top 3) | `concentration` | On / off |
| Share Bridge (points won and lost) | `shareBridge` | On / off |
| Movers in the Bridge | `bridgeItems` | Number |
| Segment CAGR Above Columns | `cagr` | On / off |
| Years Between the Periods | `years` | Number |

### Targets (`targets`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show Targets | `show` | On / off |
| One Target for All (0 = off) | `global` | Number |
| Met at (% of target) | `metAt` | Number |
| Close at (% of target) | `closeAt` | Number |
| Met Colour | `metColor` | Colour |
| Close Colour | `closeColor` | Colour |
| Missed Colour | `missedColor` | Colour |
| Colour Items by Status | `statusColors` | On / off |

### Survey Margins (`survey`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show the Margin of Error | `show` | On / off |
| Confidence | `confidence` | `0.95` (95 %), `0.9` (90 %), `0.99` (99 %) |
| Interval | `method` | `wilson` (Wilson), `normal` (Normal (Wald)) |
| Margin Text in the Labels | `marginText` | On / off |
| Test the Change vs the Compare Wave | `waveTest` | On / off |
| Plan the Next Wave: Margin Wanted (± pp, 0 = off) | `planMargin` | Number |
| Plan For | `planShare` | `worst` (Every share (worst case p = 0.5)), `observed` (Each observed share) |

### Coalition Builder (`coalition`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show Coalitions | `show` | On / off |
| Parties in the Coalition | `parties` | Text |
| List Minimal Winning Coalitions | `list` | On / off |
| Seat Sum Readout | `readout` | On / off |

### Findings (`findings`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| What Changed (findings) | `show` | On / off |
| Number of Findings | `max` | Number |
| Font Size | `fontSize` | Number |
| Text Colour | `color` | Colour |

### Smart Caption (`caption`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show | `show` | On / off |
| Position | `position` | `top` (Top), `bottom` (Bottom) |
| Font Size | `fontSize` | Number |
| Text Colour | `color` | Colour |

### Small Multiples (`smallMultiples`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Columns (0 = auto) | `columns` | Number |
| Shared Scale | `sharedScale` | On / off |
| Size Pies by Their Total | `sizeByTotal` | On / off |
| Title Font Size | `titleSize` | Number |
| Title Colour | `titleColor` | Colour |

### Annotations (`annotations`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show | `show` | On / off |
| Font Size | `fontSize` | Number |
| Colour | `color` | Colour |

### Show Condition (`showCondition`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Message When Hidden | `message` | Text |

### Data Table (`dataTable`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Table Button in the Visual | `button` | On / off |
| Open as Table | `start` | On / off |

### Zoom (`zoom`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Ctrl + Wheel Zooms, Drag Pans | `enabled` | On / off |

### Footnote (`footnote`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show | `show` | On / off |
| Source | `source` | Text |
| State the Methods | `showMethod` | On / off |
| Font Size | `fontSize` | Number |
| Text Colour | `color` | Colour |

### Tabs and Buttons (`controls`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Font Size | `fontSize` | Number |
| Text Colour | `color` | Colour |

### Accessibility (`accessibility`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Patterns (Tell Items Apart Without Colour) | `patterns` | On / off |
| Focus Outline Colour | `focusColor` | Colour |
| Focus Outline Width | `focusWidth` | Number |
| Minimum Text Size (0 = off) | `minFontSize` | Number |
| Reduce Motion | `reduceMotion` | On / off |

### Theme (`theme`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Theme | `selectedTheme` | `smartvisuals` (SmartVisuals), `dark` (Dark), `clean` (Clean (White)), `slate` (Slate) |
| Font | `font` | `inter` (Inter), `segoe` (Segoe UI), `arial` (Arial), `georgia` (Georgia) |
| Transparent Background | `transparentBg` | On / off |

### Data Colours (`dataPoint`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Colour | `fill` | Colour |

### Category Icons (`categoryIcon`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Icon | `icon` | Text |
