Skip to main content

Box and Whisker chart

Jan Pieter Posthuma

PowerBI Certified banner image for Box and Whisker chart
Power BI CertifiedCertified custom visuals are visuals in the marketplace that met certain specified code requirements and testing by the Power BI teamLearn more >

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

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680654/Asset_63d6badf-c364-4418-9011-67f4e7269927/screenshot1366x768.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680654/Asset_63d6badf-c364-4418-9011-67f4e7269927/screenshot1366x768.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680654/Asset_3a270d19-793c-41a1-99c4-2c41d347b3ab/screenshot21366x768.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680654/Asset_8d0f8e83-72d5-4501-93d7-fbda786dfa5a/screenshot31366x768.png