AppSource
Skip to main content

Box and Whisker chart

Jan Pieter Posthuma

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