# SmartVisuals Marimekko for Power BI

> Marimekko (mekko) chart for Power BI: 100 % or actual values, a Width measure, the long tail in Other, tooltips and a cost curve, free. Premium: share shift and CAGR.

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

## What is free

- **100 % or actual values**: The 100 % Marimekko or the bar Mekko in your units, as vertical columns or horizontal bars.
- **A Width measure**: For when the values are averages, ratios or prices and cannot set the column width themselves; the footnote names it.
- **Long tail into Other**: Beyond the top five per column, players under 5 % fold into Other, named on hover; your own Top N per column on request.
- **Labels that fit**: Value, % of column, % of total and player names, shown only where they fit and dropped whole otherwise; outside labels with leader lines for thin cells in the last column.
- **Axes, totals and sorting**: Column totals, a value axis, axis titles named after your fields, and sorting of columns and players.
- **Cost curve**: Capacity as width, unit cost as height, sorted by cost, with a capacity-weighted average in the caption.
- **Correct shares**: Percentages rounded to add up to 100 in every column, negatives left out and counted, and edit-mode hints when a ratio needs a Width measure.
- **Power BI features**: Tooltips on every cell 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), 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

- **Share shift**: Share shift in points per player within each column, with last period's boundary drawn in every cell.
- **Segment CAGR**: Each market's compound annual growth above its column, and column growth in the tooltip.
- **Relative market share and focus player**: Each player's share over the largest rival's, and one player kept in colour across every market.
- **Where is the prize**: The focus player's open headroom in every market, outlined and ranked, up to the whole market or a share you set.
- **Target per market**: A "vs target" band above the columns with met, close or missed.
- **Cost curve demand line**: The demand line and the marginal plant that serves the last unit.
- **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 |
| Width | `width` | Measure | Optional | Column width (else each column's total) |
| 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 |

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

### Marimekko (`marimekko`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Chart | `mode` | `percent` (100 % Marimekko), `actual` (Actual values (bar Mekko)), `costCurve` (Cost curve (variable-width bars by height)) |
| Orientation | `orientation` | `vertical` (Vertical columns), `horizontal` (Horizontal bars) |
| Sort Columns | `sortColumns` | `desc` (Largest first), `asc` (Smallest first), `name` (Name), `data` (Data order) |
| Sort Segments | `sortSegments` | `desc` (Largest first (per column)), `global` (Same order in every column), `name` (Name), `data` (Data order) |
| Top N Segments per Column (0 = automatic) | `topSegments` | Number |
| Fold Small Players into Other | `autoOther` | On / off |
| Labels Outside Thin Cells | `outsideLabels` | On / off |
| Column Labels | `columnLabels` | On / off |
| Column Totals | `columnTotals` | On / off |
| Cell Percentages | `cellPercent` | `column` (% of column), `total` (% of total) |
| Hide Labels in Cells Below (% of area) | `minLabelShare` | Number |
| Value Axis | `percentAxis` | On / off |
| Column Axis Title | `xTitle` | Text |
| Value Axis Title | `yTitle` | Text |
| Relative Market Share | `relativeShare` | On / off |
| Focus Player | `focusPlayer` | Text |
| Where Is the Prize | `prize` | On / off |
| Prize Labels | `prizeLabels` | On / off |
| Prize: Up to a Share of (%, 0 = whole market) | `prizeShare` | Number |
| Cost Curve: Demand (0 = off) | `threshold` | Number |
| Demand Line Label | `demandLabel` | On / off |
| % of Target Above Columns | `targetBand` | 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 |

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

### Axis Text (`axes`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show Axis Values and Titles | `show` | 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 |
