https://store-images.s-microsoft.com/image/apps.26445.6ca5fad2-ac9b-44e4-885e-58f92da952a9.7e0c4806-a5f0-4cc2-ad95-dafb5d503f12.6244d2a9-c95b-4e84-95c4-229ee38887ed.png

Box and Whisker chart

by DataScenarios

Microsoft PBI Certified
(84 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.6ca5fad2-ac9b-44e4-885e-58f92da952a9.7e0c4806-a5f0-4cc2-ad95-dafb5d503f12.a12703ec-79db-423a-ba38-9fd99c094a61.png
https://store-images.s-microsoft.com/image/apps.38646.6ca5fad2-ac9b-44e4-885e-58f92da952a9.7e0c4806-a5f0-4cc2-ad95-dafb5d503f12.49f0a8bd-8190-486e-a4d1-eba2c4a4b914.png
https://store-images.s-microsoft.com/image/apps.27318.6ca5fad2-ac9b-44e4-885e-58f92da952a9.7e0c4806-a5f0-4cc2-ad95-dafb5d503f12.eac0aa3c-0deb-4e29-836c-b658e1e8aa7c.png