# SmartVisuals Funnel & Pyramid for Power BI

> Power BI funnel and pyramid chart with a stage order field, % of first and previous, drop, lost and leak ribbons, free. Premium: z-test per step and pipeline forecast.

- Page: https://www.smartvisuals.io/visuals/funnel-pyramid
- Fields and settings: https://www.smartvisuals.io/visuals/funnel-pyramid/settings
- Microsoft Marketplace: https://marketplace.microsoft.com/en-us/product/smartvisuals.smartvisuals-funnel-pyramid?tab=overview
- Package: https://www.smartvisuals.io/downloads/smartvisuals-funnel-pyramid-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): `smartvisualsFunnelPyramidBF281E689F48B9242B4CA92FDB7DDAB6`

## What is free

- **Stage order field**: Stages follow your sort column (1, 2, 3...), not the data order or the size. Without it the funnel keeps the data order.
- **The numbers a pipeline review needs**: % of first, % of previous, drop % and lost per stage, and a conversion pill between stages.
- **Leak ribbons**: What each step loses peels off the funnel, labelled, with its thickness relative to the largest loss.
- **Shapes**: Vertical or horizontal; tapered, straight bars or curved; connector areas; a minimum stage width with the true value labelled and footnoted.
- **Pyramid and inverted pyramid**: Equal or proportional level heights, for safety pyramids and headcount pyramids.
- **Stacked stages**: A Segment field stacks every stage by region, channel or product, with a segment legend.
- **Data checks and no row cap**: Edit mode names duplicate stages, a later stage larger than the one before and negative stages. The free tier has no row cap.
- **Smart caption and footnote**: "492 of 11.4K reach Won (4.3 % overall). The weakest step is Lead → Qualified at 43 %." The footnote states the methods.
- **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 (Executive, IBCS (Finance), Minimal, Presentation, Print, Infographic), four themes, four fonts, conditional formatting (fx), colour rules, 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

- **Compare with last period or plan**: A dashed outline per stage and the conversion change in points on every pill.
- **Two-proportion z-test per step**: Stars on the steps that changed significantly, when the measure is a count; the footnote says why a step was not tested. Golden-tested against scipy.
- **Targets per stage**: A Target field per stage, met, close or missed in the status colours.
- **Segments side by side and small multiples**: One funnel per region on a shared scale, or one panel per value of a Small multiples field.
- **Expected value and pipeline coverage**: Win probability on what is in each stage now, each deal once and Won at 100 %, for cumulative or in-stage data; coverage of the forecast or the open pipeline against a quota.
- **What if**: Lift one step by N points and see the extra won, drawn as a ghost of the lifted funnel.
- **Loss reasons**: A Loss reason field splits every leak ribbon by reason, and the findings name the main one.
- **Findings**: Up to five sentences with "how calculated": the biggest leak change, the significant steps, missed targets, the forecast.

## 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 |
| Stage order | `stageOrder` | Measure | Optional | Sort key of the stages (1, 2, 3...) |
| Win probability | `probability` | Measure | Optional | Chance each stage closes (0-1 or %): weighted pipeline (premium) |
| 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 |
| Loss reason | `lossReason` | Column | Optional | Why the lost left each step (blank = still open or won): splits the leak ribbons by reason (premium) |
| Show condition | `showCondition` | Measure | Optional | A measure returning 1 / TRUE to show the chart, 0 / FALSE / blank to show a message instead |

## 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`).

### 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 |

### Funnel & Pyramid (`funnel`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Chart | `style` | `funnel` (Funnel), `pyramid` (Pyramid), `inverted` (Inverted pyramid) |
| Orientation | `orientation` | `vertical` (Vertical), `horizontal` (Horizontal) |
| Shape | `shape` | `tapered` (Tapered), `bars` (Straight bars), `curved` (Curved) |
| Level Heights | `heights` | `equal` (Equal), `proportional` (Proportional to value) |
| Connector Areas | `connectors` | On / off |
| Minimum Stage Width (%) | `minWidth` | Number |
| Segment Field As | `segments` | `stacked` (Stacked inside each stage), `sideBySide` (Side by side (one funnel per segment)) |
| Conversion Pills | `pills` | On / off |
| Leak Ribbons (What Each Step Loses) | `leaks` | On / off |
| Leak Ribbon Labels | `leakLabels` | On / off |
| Lane Titles | `laneTitles` | On / off |
| % of First Stage | `showPctFirst` | On / off |
| % of Previous Stage | `showPctPrevious` | On / off |
| Drop % | `showDrop` | On / off |
| Lost (Absolute) | `showLoss` | On / off |
| Data Checks (edit mode) | `diagnostics` | 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 |

### Significance (`significance`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Test the Change | `show` | On / off |
| Significance Level | `alpha` | `0.05` (95 % (α = 0.05)), `0.01` (99 % (α = 0.01)), `0.1` (90 % (α = 0.10)) |
| Values Are | `valuesAre` | `auto` (Automatic (whole numbers, not currency or %)), `counts` (Counts (opportunities, people, orders)), `amounts` (Amounts (revenue, value): not tested) |
| Test Against | `reference` | `compare` (The Compare field), `firstSegment` (The first segment) |

### Pipeline & Forecast (`pipeline`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show Expected Value | `show` | On / off |
| Stages Are | `stagesAre` | `cumulative` (Cumulative (each stage counts everyone who reached it)), `inStage` (In stage (each stage counts only those there now)) |
| Last Stage Is Won (counted at 100 %) | `lastIsWon` | On / off |
| Pipeline Coverage | `coverage` | `off` (Off), `forecast` (Forecast (expected + won) ÷ quota), `open` (Open pipeline ÷ quota) |
| Quota (0 = the last stage's Target) | `quota` | Number |
| Forecast Line Under the Chart | `totalLine` | On / off |

### What If (`whatIf`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Lift One Step | `show` | On / off |
| Step Into Stage (blank = the weakest step) | `step` | Text |
| Uplift (percentage points) | `uplift` | Number |
| Uplift Labels | `showText` | 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 |
