Series Threshold
The Series Threshold card publishes, or withholds, one chart at a time. It asks of every series the question the Global Threshold asks of the whole visual — "is this base big enough to be shown?" — and answers it per small multiple, so a market with 40 respondents can be withdrawn while its neighbours keep being drawn.
The left operand is never typed: it is the smallest base of the series, taken from the Base field well over the categories actually plotted. The card is therefore inert in a visual with no Base field — nothing is drawn, nothing is hidden.
| Level | Test | Effect |
|---|---|---|
| Warning | min(base) < Warn below | the chart is drawn, with a message under it |
| Critical | min(base) < Hide below | the chart is not drawn; a message takes its place |
Critical is tested first, so a series under both thresholds is withdrawn rather than warned. A threshold left at 0 switches its level off — the same convention as the Global Threshold, where both operands at 0 leave the conditional message disabled. That is what lets you use the warning alone, the hiding alone, or the two together as a graded rule:
Warn below 80 ⚠ Low base (62)
Hide below 50 Not shown — smallest base is under (50)
Warning
| Property | Description | Default |
|---|---|---|
| Warn below | The series is flagged under this base | 0 (off) |
| Warning message | Text shown under the chart while the warning holds | ⚠ Low base (%BASE) |
| Font / Text Color | Appearance of the message | Segoe UI 9 italic, #B06000 |
| Background / Border | Whether the message draws a filled and outlined box | Off, off |
%BASE is replaced by the smallest base of that series. It is what makes the warning say
which base is low rather than merely that one is — the number cannot come from a setting,
since it differs from one small multiple to the next.
The warning sits in a band reserved at the foot of every cell, never over the chart. The band is taken off every cell, including the ones carrying no warning: charts of different radii on the same grid would read as charts of different magnitudes.
Critical
The message that replaces a withdrawn chart is built from three fields, for the same reason the Note splits its caption in three — only the number has to come from the model:
| Property | Description | Default |
|---|---|---|
| Hide below | The series is withdrawn under this base | 0 (off) |
| Prefix | Wording in front of the value | Not shown — smallest base is under ( |
| Value | The number between the wordings | (empty) |
| Suffix | Wording after the value | ) |
| Font / Text Color | Appearance of the message | Segoe UI 10, #C00000 |
| Background / Border | Whether the message draws a filled and outlined box | On, on |
Prefix Not shown — smallest base is under (
Value (empty, or bound to a measure through fx)
Suffix )
Not shown — smallest base is under (50)
Value left empty writes the Hide below threshold — the number the sentence is about,
and the one nobody should have to retype next to the setting that already carries it. Bind it
through fx when the threshold lives in the model, or write %BASE in it to publish the
base that was actually found instead of the rule that rejected it.
The wording being an ordinary visual setting rather than a DAX measure leaves one place to translate per visual, which is the whole point of splitting the sentence up.
Clear Prefix, Value and Suffix and the chart is simply absent — the cell stays empty, the series title still names it. That is the discreet form of the same rule.
Which series keeps its title
A withdrawn series keeps its series title: without it, an empty cell in the grid names nothing, and a reader cannot tell which market was withheld from one that was never in the report. Everything else goes — slices, data labels, target line, significance icons — and the cell stops responding to hover and to click, so a withdrawn series cannot be cross-filtered into another visual either.
A per-market threshold
Warn below and Hide below are both conditional-formatting fields. Bound to a measure through fx, they are evaluated inside each legend group, which gives one threshold per series — the publication rule of a country, read from the model rather than retyped in the visual. The value typed on the card stays the fallback for the series the measure says nothing about.
The wordings work the same way, so a message can name the market it is about.
Relationship with the other two cards
| Global Threshold | Series Threshold | Note | |
|---|---|---|---|
| Scope | the whole visual | one series | the whole visual |
| What it does | erases everything | withdraws one chart, or flags it | decorates, never removes |
| Typical use | nothing here may be published | this market may not, the others may | the base deserves a caveat |
The three stack cleanly: a Note carrying the overall base, a Series Threshold withdrawing the markets that fall short, and a Global Threshold for the case where the page filters leave nothing worth showing at all.
The card is new and, for now, exposed by the Pie Chart alone. It needs a chart that is already split into one drawing per series, which is what the small multiples give it — that is also why the Column Chart solves the same problem differently, by hiding individual columns.