Box and Whisker chart

isualize 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
Membership

***** Related Blog Posts *****
Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique
Custom Dynamic Segmentation Using DAX In Power BI

***** Related Video Tutorials *****
Create Dynamic Visuals Based On Ranking in Power BI w/DAX

Outlier Detection & Visualization in Power BI – Advanced DAX
How To Use Virtual Tables With COUNTROWS in Power BI – DAX Formula Technique
RANKX Considerations – Power BI & DAX Formula Concepts
Manufacturing Operations – Power BI Showcase

Center of Excellence

***** Related Course Modules *****
Ultimate Beginners Guide to Power BI
Power BI Super Users Workshop
Solving Analytical Scenarios w/ Power BI & DAX
Advanced Analytics in Power BI
Financial Reporting w/ Power BI
Power BI Showcases

***** Related Support Forum Posts*****
Custom Visual AppStore
Custom Visuals vs Standard Visuals
Power BI – Creativity