tcviz VISUALS TO POWER BI

Box & Whisker by TCViz

A box plot for Power BI: the median, the middle half, the normal range and the outliers of every category.
From “the average is 70” to how consistent it really is in three fields.

Use cases
Quality control
Cycle times
Resolution times
Delivery days
Salaries
Order values
Scores
Lab results
Shift your mindset: Two teams with the same average can be one predictable and one erratic. The box shows which.
1
0–1 min

Three fields

Category (the boxes), Value (the measure) and Detail (rows) (the ID of each row).

  • Start page lists the three steps
  • Hierarchy in Category: drilldown
  • Tooltips and report page tooltips
  • The measure's own number format
2
1–2 min

Read the box

Median line, box from Q1 to Q3, whiskers to the last value within 1.5 × IQR, dots beyond them.

IQR = Q3 − Q1  |  whiskers ≤ 1.5 × IQR (Tukey)
  • n under every box
  • Method named in the tooltip
3
2–4 min · Pro

Compare groups

Group puts boxes side by side with a legend; Small multiples repeats the chart on one shared scale.

Category = Plant · Group = Shift · Small multiples = Year
5 numbers in one box
Templates
6
incl. IBCS style
Quartile methods
3
Excel INC · EXC · hinges
Desktop rows
30k
more in the service
Languages
12
format pane and texts
4
4–6 min · Pro

See every value

All points with jitter, the mean, notches and a violin behind each box.

  • Colour by quartile
  • Sort by median, mean, IQR, n
  • Two reference lines
  • Statistics table per box
5
6–8 min

Style it in one click

Templates Clean, Classic, Minimal, Contrast, Compact, IBCS style — then adjust anything; your settings win.

  • fx on box colour
  • Vertical or horizontal
  • Axis fonts, bold, range
  • Format on the canvas
6
8–10 min

Avoid common mistakes

  • No Detail: one flat line per box
  • Reading a box of n = 8 as solid
  • Comparing panels with own scales
  • One ID per row in Detail (rows)
  • Watch the warning icon: it says when rows were left out
Analysis workflow with Box & Whisker
Connect
your data
›
One box per
category
›
Read the
spread
›
Spot the
outliers
›
Compare
groups
›
Click to
filter
›
Present
with impact
Not only “how much on average” — how consistent, and where the exceptions are.
Key benefits
The spread, not just the average
Power BI has no built-in box plot; this one says exactly how it counts.
Honest about sample size
n under every box, so 12 rows are not mistaken for 12,000.
Native Power BI interactions
Click a box to filter the page, Ctrl+click for several; bookmarks keep the selection.
Private by design
No network requests: every statistic is computed inside your report.
Key takeaways
Detail (rows) turns one total per category into a real distribution.
Quartiles match Excel QUARTILE.INC unless you choose another method.
Notches that do not overlap suggest the medians really differ.
Pro features are drawn on your data under a “Pro preview” watermark while you edit.
Keyboard: arrows move box to box, Enter selects.
Pro from 0.99 USD a month.Groups, small multiples, points, violin, table.
Format pane — quick reference
Style — Clean, Classic, Minimal, Contrast, Compact, IBCS style
Boxes — Orientation, colour (fx), border, width, radius, opacity
Whiskers · Statistics — Rule, method, n, median labels, mean, notches
Points · Violin — Jitter, size, outliers, violin colour
Axes · Reference lines — Range, gridlines, fonts, bold, targets
Table · Small multiples — Header, banding, columns, titles, panels