# SmartVisuals Bar & Column for Power BI

> Power BI bar and column chart: stacked, lollipop, dumbbell, population pyramid, Top N + Other and small multiples free. Premium: variance to plan and last year.

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

## What is free

- **Every bar layout**: Clustered, stacked, 100 % stacked and overlapped (lipstick), as bars or columns; dates become columns on their own.
- **Lollipop, dumbbell and pyramid**: Lollipops with data point markers, dumbbells, pill shapes and a back-to-back population pyramid.
- **Top N + Other**: Keep the largest or smallest categories and fold the rest into Other; hover Other to see what it holds.
- **Small multiples**: One panel per value with a shared or own value axis and the same category order in every panel.
- **Sorting that needs no DAX**: By value, name, data order or one legend segment; stacking order; a button that lets readers re-sort.
- **Labels in your model's format**: Value, % of category, both, or % of total; stack totals; change % to the previous bar; label backgrounds.
- **Targets**: A tick, dot or line per bar from a Target measure, target labels and the shortfall hatched.
- **Analytics lines**: Three reference lines and a band, a linear trend with R², a Pareto line with the 80 % point, error bars and an axis break.
- **Difference highlight and Total bar**: A bracket between any two bars with change, per cent and CAGR for dates; a Total bar; a logarithmic axis.
- **Colour rules with a legend**: Power BI fx colours, plus our own rules (above or below a value, highest and lowest, dim the rest) that also work with a legend.
- **Interaction**: Pan and zoom for long lists, drill down and expanded levels, highlight, cross-filter, report page tooltips, dynamic format strings, on-object formatting.
- **Templates and themes**: Executive, IBCS, Minimal, Presentation and Print in one click, style as JSON, and four themes: SmartVisuals, Dark, Clean and Slate.
- **Accessibility and 20 languages**: Keyboard navigation of every bar, screen-reader summary and data table, high contrast, patterns, reduce motion, in 20 languages.

## What premium adds

- **Previous year from your date**: Year to date, latest year, quarter or month against the same days a year earlier, from a Date field, a date axis or your own measure.
- **Plan and forecast as IBCS bars**: Previous year grey behind, plan outlined, forecast hatched; overlapping, beside or as markers; per legend segment too.
- **Δ and Δ% variance charts**: Variance bars and pins on the same axis, two comparisons at once, met or missed colours, lower is better for costs.
- **Rank change**: ▲3, ▼1 or new next to each category, ranked before Top N so a site that fell out of the chart still counts.
- **Findings panel**: Total change, the drivers of it, how many are below plan, concentration, outliers and the biggest movers, each with how it was calculated.
- **Clustered and stacked**: One stack per measure side by side, such as actual and plan each split by product line; sort by variance.

## Fields

| Field | Internal name | Takes | Needed | What it is for |
| --- | --- | --- | --- | --- |
| Category | `category` | Column | Optional | The bars: sites, products, months. Add several fields to drill down. |
| Values | `values` | Measure | Optional | One or more measures; several measures are clustered, stacked or compared side by side. |
| Legend | `legend` | Column | Optional | Splits each bar into segments (stacked) or series (clustered). |
| Small multiples | `facet` | Column | Optional | One small chart per value of this field. |
| Date (previous year) | `period` | Column | Optional | A date field: the visual sums the current period and the same period a year earlier (premium comparison). |
| Previous year | `py` | Measure | Optional | Optional: your own previous-year measure (otherwise derived from the date). |
| Plan / budget | `plan` | Measure | Optional | Compared with the actual as an outlined bar and variance (premium). |
| Forecast | `forecast` | Measure | Optional | Compared with the actual as a hatched bar and variance (premium). |
| Target | `target` | Measure | Optional | A marker on every bar (free). |
| Error bar: lower | `errLow` | Measure | Optional | Lower bound (or distance below) of an error bar. |
| Error bar: upper | `errHigh` | Measure | Optional | Upper bound (or distance above) of an error bar. |
| Annotation | `annotation` | Measure | Optional | A text measure drawn as a note on its bar. |
| Icon or image | `image` | Measure | Optional | An emoji, a short text or a data:image URI per category, shown next to its label. |
| Tooltips | `tooltips` | Measure | Optional | Extra measures in the tooltip. |

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

### Style template (`presets`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Style template | `template` | `none` (None (defaults)), `executive` (Executive), `ibcs` (IBCS (finance)), `minimal` (Minimal), `presentation` (Presentation), `print` (Print), `custom` (Custom) |
| Applied | `applied` | Text |
| Style as JSON | `json` | Text |

### Layout (`layout`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Chart type | `layout` | `clustered` (Clustered), `stacked` (Stacked), `percent` (100 % stacked), `overlapped` (Overlapped (lipstick)), `lollipop` (Lollipop), `dumbbell` (Dumbbell), `pyramid` (Population pyramid (back to back)), `clusteredStacked` (Clustered and stacked) |
| Orientation | `orientation` | `auto` (Automatic (dates as columns, categories as bars)), `column` (Columns (vertical)), `bar` (Bars (horizontal)) |
| Bar shape | `shape` | `theme` (From theme), `square` (Square), `rounded` (Rounded), `pill` (Pill) |
| Gap between categories (%) | `gap` | Number |
| Gap between series (%) | `innerGap` | Number |
| Minimum bar thickness (px) | `minThickness` | Number |
| Hide zero and blank categories | `hideZero` | On / off |
| Total bar | `totalBar` | On / off |
| Total label | `totalLabel` | Text |
| Responsive layout | `responsive` | On / off |

### Sorting (`sorting`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Sort by | `by` | `auto` (Automatic (dates in time order, else largest first)), `none` (Data order (visual header sort)), `valueDesc` (Value, largest first), `valueAsc` (Value, smallest first), `nameAsc` (Name, A to Z), `nameDesc` (Name, Z to A), `segment` (A legend segment), `variance` (Variance to comparison) |
| Segment to sort by | `segment` | Text |
| Stacking order | `stackOrder` | `legend` (Legend order), `sizeDesc` (Largest segment at the base), `sizeAsc` (Smallest segment at the base) |
| Let readers change the sort | `readerSort` | On / off |
| Sort button text size | `buttonFontSize` | Number |

### Top N (`topN`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show Top N only | `show` | On / off |
| Number of categories | `count` | Number |
| Keep | `mode` | `top` (Largest values), `bottom` (Smallest values) |
| Group the rest as Other | `other` | On / off |
| Other label | `otherLabel` | Text |

### Small multiples (`smallMultiples`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Columns (0 = automatic) | `columns` | Number |
| Shared value axis | `sharedAxis` | On / off |
| Same category order in every panel | `sharedOrder` | On / off |
| Panel titles | `showTitles` | On / off |
| Panel title size | `titleSize` | Number |
| Panel title colour | `titleColor` | Colour |

### Data labels (`labels`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show data labels | `show` | On / off |
| Content | `content` | `value` (Value), `percent` (% of category), `valueAndPercent` (Value and % of category), `percentTotal` (% of total) |
| Position | `position` | `auto` (Automatic), `inside` (Inside end), `outside` (Outside end), `base` (Inside base) |
| Text size | `fontSize` | Number |
| Colour | `color` | Colour |
| Display units | `units` | `auto` (Auto), `none` (None), `K` (Thousands), `M` (Millions), `B` (Billions) |
| Decimal places (-1 = automatic) | `decimals` | Number |
| Hide segment labels below (% of category) | `hideBelow` | Number |
| Total labels on stacks | `totals` | On / off |
| Label background | `background` | On / off |
| Background colour | `backgroundColor` | Colour |
| Change % to the previous bar | `prevChange` | On / off |

### Value axis (`valueAxis`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show value axis | `show` | On / off |
| Scale type | `scale` | `linear` (Linear), `log` (Logarithmic) |
| Axis title | `showTitle` | On / off |
| Title text | `title` | Text |
| Start | `min` | Text |
| End | `max` | Text |
| Display units | `units` | `auto` (Auto), `none` (None), `K` (Thousands), `M` (Millions), `B` (Billions) |
| Decimal places (-1 = automatic) | `decimals` | Number |
| Text size | `fontSize` | Number |
| Colour | `color` | Colour |
| Axis break for an outsized bar | `axisBreak` | On / off |

### Category axis (`categoryAxis`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show category axis | `show` | On / off |
| Axis title | `showTitle` | On / off |
| Title text | `title` | Text |
| Text size | `fontSize` | Number |
| Colour | `color` | Colour |
| Maximum label width (% of the visual) | `maxWidth` | Number |
| Column label rotation | `rotate` | `auto` (Automatic), `0` (Horizontal), `45` (45 degrees), `90` (Vertical) |
| Show icons or images | `icons` | On / off |
| Rank change vs previous year | `rankChange` | On / off |

### Legend (`legend`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show legend | `show` | On / off |
| Position | `position` | `top` (Top), `bottom` (Bottom), `left` (Left), `right` (Right) |
| Title | `showTitle` | On / off |
| Title text | `titleText` | Text |
| Text size | `fontSize` | Number |
| Colour | `color` | Colour |

### Gridlines (`gridlines`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show gridlines | `show` | On / off |
| Style | `style` | `theme` (From theme), `solid` (Solid), `dashed` (Dashed), `dotted` (Dotted) |
| Colour | `color` | Colour |
| Width | `width` | Number |

### Data point markers (`markers`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Shape | `shape` | `circle` (Circle), `square` (Square), `diamond` (Diamond) |
| Size | `size` | Number |
| Stem width | `stemWidth` | Number |

### Colour rules (`colorRules`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Highlight the highest bar | `highlightMax` | On / off |
| Highest colour | `maxColor` | Colour |
| Highlight the lowest bar | `highlightMin` | On / off |
| Lowest colour | `minColor` | Colour |
| Values above | `above` | Text |
| Colour above | `aboveColor` | Colour |
| Values below | `below` | Text |
| Colour below | `belowColor` | Colour |
| Dim bars no rule matches | `dimOthers` | On / off |

### Target (`target`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show target markers | `show` | On / off |
| Marker | `style` | `tick` (Tick across the bar), `dot` (Dot), `line` (Line through the bars) |
| Colour | `color` | Colour |
| Width | `width` | Number |
| Target labels | `labels` | On / off |
| Target label size | `labelSize` | Number |
| Mark bars below target | `state` | On / off |

### Error bars (`errorBars`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show error bars | `show` | On / off |
| Fields are | `mode` | `bounds` (Lower and upper bounds), `deltas` (Distances below and above) |
| Colour | `color` | Colour |
| Width | `width` | Number |

### Annotations (`annotations`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show annotations | `show` | On / off |
| Note 1 category | `category1` | Text |
| Note 1 text | `text1` | Text |
| Note 2 category | `category2` | Text |
| Note 2 text | `text2` | Text |
| Text size | `fontSize` | Number |
| Colour | `color` | Colour |

### Difference highlight (`difference`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show the difference between two bars | `show` | On / off |
| From category | `from` | Text |
| To category | `to` | Text |
| Show CAGR (dates) | `cagr` | On / off |
| Colour | `color` | Colour |
| Show the label | `showLabel` | On / off |
| Text size | `fontSize` | Number |

### Reference lines (`refLines`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Line 1 | `line1` | `none` (None), `value` (A value), `average` (Average), `median` (Median), `percentile` (Percentile), `min` (Minimum), `max` (Maximum) |
| Line 1 value | `line1Value` | Number |
| Line 1 percentile | `line1Percentile` | Number |
| Line 1 label | `line1Label` | Text |
| Line 1 colour | `line1Color` | Colour |
| Line 1 style | `line1Dash` | `solid` (Solid), `dashed` (Dashed), `dotted` (Dotted) |
| Line 2 | `line2` | `none` (None), `value` (A value), `average` (Average), `median` (Median), `percentile` (Percentile), `min` (Minimum), `max` (Maximum) |
| Line 2 value | `line2Value` | Number |
| Line 2 percentile | `line2Percentile` | Number |
| Line 2 label | `line2Label` | Text |
| Line 2 colour | `line2Color` | Colour |
| Line 2 style | `line2Dash` | `solid` (Solid), `dashed` (Dashed), `dotted` (Dotted) |
| Line 3 | `line3` | `none` (None), `value` (A value), `average` (Average), `median` (Median), `percentile` (Percentile), `min` (Minimum), `max` (Maximum) |
| Line 3 value | `line3Value` | Number |
| Line 3 percentile | `line3Percentile` | Number |
| Line 3 label | `line3Label` | Text |
| Line 3 colour | `line3Color` | Colour |
| Line 3 style | `line3Dash` | `solid` (Solid), `dashed` (Dashed), `dotted` (Dotted) |
| Reference band | `band` | On / off |
| Band from | `bandFrom` | Number |
| Band to | `bandTo` | Number |
| Band colour | `bandColor` | Colour |
| Band label | `bandLabel` | Text |
| Show labels | `showLabels` | On / off |
| Label text size | `labelSize` | Number |
| Label colour | `labelColor` | Colour |

### Trend line (`trend`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show linear trend | `show` | On / off |
| Colour | `color` | Colour |
| Style | `dash` | `solid` (Solid), `dashed` (Dashed), `dotted` (Dotted) |
| Show slope and R² | `showR2` | On / off |
| Label text size | `labelSize` | Number |

### Pareto line (`pareto`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show cumulative % line | `show` | On / off |
| Colour | `color` | Colour |
| Mark the 80 % point | `mark80` | On / off |
| Show the % scale | `showPercent` | On / off |
| Label text size | `labelSize` | Number |

### Comparison & variance (`compare`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Compare (premium) | `show` | On / off |
| Previous year | `py` | On / off |
| Plan / budget | `plan` | On / off |
| Forecast | `forecast` | On / off |
| Period of the Date field | `window` | `ytd` (Year to date), `year` (Latest full year), `quarter` (Latest quarter), `month` (Latest month) |
| Comparison shown as | `display` | `ghost` (Ghost bar behind), `overlap` (Overlapping bar), `side` (Bar beside), `marker` (Marker) |
| Variance charts | `variance` | `none` (None), `abs` (Δ (absolute)), `pct` (Δ% (pins)), `both` (Δ and Δ%) |
| Variance against | `varianceOf` | `auto` (Automatic (plan, else previous year)), `py` (Previous year), `plan` (Plan / budget), `forecast` (Forecast) |
| Second variance chart | `second` | On / off |
| Variance chart titles | `varianceTitles` | On / off |
| Variance labels | `varianceLabels` | On / off |
| Variance text size | `varianceFontSize` | Number |
| Colour bars by met / missed | `metColors` | On / off |
| Lower is better (costs) | `lowerIsBetter` | On / off |
| IBCS notation | `ibcs` | On / off |

### Narrative (`narrative`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| One-line caption | `caption` | On / off |
| Findings panel (premium) | `findings` | On / off |
| Findings position | `position` | `auto` (Automatic), `right` (Right), `bottom` (Bottom) |
| Text size | `fontSize` | Number |
| Colour | `color` | Colour |

### Accessibility (`accessibility`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Focus outline colour | `focusColor` | Colour |
| Focus outline width | `focusWidth` | Number |
| Minimum text size | `minFontSize` | Number |
| Distinguish series without colour | `distinguish` | On / off |
| Grow animation | `animate` | On / off |
| 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 |

### Series colours (`seriesColors`)

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

### Data colours (`dataPoint`)

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