https://store-images.s-microsoft.com/image/apps.26445.93259b11-451c-4ed8-a928-fd9c292546c4.8a563018-b33b-4a1c-9395-7f2020ba9aeb.ff8a86be-26c0-49fd-a2a4-aa36b130baee

Box and Whisker chart

by DataScenarios

Microsoft PBI Certified
(38 ratings)
Download SampleInstructions

Visualize a dataset in an effective way as a five-number summary (mean, median, quartiles, min/max)

The Box and whisker plot chart for Power BI is a convenient way of graphically depicting groups of numerical data through their quartiles.

It shows basic statistical information (five-number summary) of a dataset:

  • the 1st and 3rd quartile (box)
  • the median (line)
  • the mean (dot)
  • minimum and maximum value, 1.5x interquartile range [IQR] or custom percentile value (whiskers)

Other options:

  • Add static reference line(s)
  • Option to show outliers
  • Option to show median/mean indicators
  • Optional support for highlight and 'Fixed Categories'
  • Label formatting options, including font size and font family
  • Option to enable data labels

Release Notes

[2.5.3.0]

NEW

  • Support for bookmarks
  • Added 'Log' axis
  • Support for 'Report tooltips'
  • Added High Contrst support

CHANGED

  • Option to incluse zero/null
  • Fix for start/end axis values
  • Removed fixed dataPoint limit
  • Improved highlight support

[2.1.0.0]

NEW

  • Support for highlighting
  • Add 'sampling' details to tooltips
  • Add changing category axis label orientation

CHANGED

  • Changing data colors fixed
  • Outlier tooltips shows now correct values

[2.0.0.0]

NEW

  • Fixed value reference line
  • Axis formatting options (font, text size, decimals, units)
  • Axis titles + formatting options
  • Data labels formatting

CHANGED

  • Quartile calculation (excluding/including)
  • Extra custom whisker type: custom percentile values
  • Fixed color for all categories
  • Coloring option to mean and median indicators

[1.0.0.0]

  • First release to the Office Store

This is an open source visual. Code is available at my GitHub: https://github.com/liprec/powerbi-boxWhiskerChart

- Jan Pieter Posthuma, DataScenarios

Visual capabilities

This visual is certified by Power BI

At a glance

https://store-images.s-microsoft.com/image/apps.49753.93259b11-451c-4ed8-a928-fd9c292546c4.8a563018-b33b-4a1c-9395-7f2020ba9aeb.2603618c-6520-40b6-b043-32baf6756152
https://store-images.s-microsoft.com/image/apps.38646.93259b11-451c-4ed8-a928-fd9c292546c4.8a563018-b33b-4a1c-9395-7f2020ba9aeb.b61dd471-eb08-46a8-9509-d3266f8601c3
https://store-images.s-microsoft.com/image/apps.27318.93259b11-451c-4ed8-a928-fd9c292546c4.8a563018-b33b-4a1c-9395-7f2020ba9aeb.37bd1675-0772-4f16-a3ea-495ba08f650d