Box and Whisker with Points for Power BI
Step 1 – Get the visual
You can get the visual from our website, Microsoft AppSource or Power BI desktop/web.
a. Website - Go to the visual page and click on ‘Get Trial’ button. You will be redirected to the pricing page where you will provide your email id and click on the ‘Download Visual’ button.
You will receive a mail which will contain the link to download .pbiviz file and a free trial license.
Step 2 – Map your data in the fields available
After importing the visual in Power BI, map data in the given fields.
Up to 3 values can be mapped which can be further broken down using legend.
Here we have mapped 'Tree Type' in Category, 'Sum of Tree Height' in Value 1, 'Sum of Produce (Kg)' in Value 2, 'Sum of Area (sqm) in Value 3, 'Orchard' in Legend and 'Tooltip' in Tooltip.
In case you want to add small multiple, you can map that too.
Step 3 – Format your visual further
a. License Details - If you want to check how your visual works in other Power BI platforms besides Power BI desktop, you have to fill License Details section.
To know more about License Details section, click here.
b. Layout Section – In case you don’t want to see the Sorting and Analytics icons present on the top left of the visual. You can switch off the Show Toolbar button.
c. Chart and Legend Section - To know more about these sections, please click the below links
d. X/Y Axis – You can format the X and Y Axis under these sections. You can choose the type of the axis, axis color, axis label formatting and many more.
For more details visit Axis section.
e. Value Section – The Value section has various groups like Box, Box data, Whiskers, Notches, Mean, Box points, Box outlier points and Tooltip. Each group has its corresponding properties for customizing the box chart.
Box - Box group has options like flip, transparency, fill color, border width and border color.
Box data - Box data group has properties to include Standard deviation and to select different Quartile methods (Linear, Include median and Exclude median).
Box points - It has properties to customize point properties like position, jitter, transparency, color, size, shape, etc.
Additionally, you can also customize outlier points.
Box Whiskers - It has properties to customize whiskers, width can be customized and Upper whisker & lower whisker value can be 1.5 x IQR, Max/Min value or Custom.
Notches and Mean - Notches can be enabled or disabled, with customizable width. Similarly, the mean can be toggled on or off, and its color can be adjusted.
Tooltip - Tooltip can be shown on box or points or both.
Step 4 – Conditional Color Formatting and Sorting
a. Conditional Color Formatting - You can color the chart based on data fields or rules. You can use Conditional Color Formatting documentation to learn more about this section.
Map the data based on which you want to color them. Click on ‘Conditional Color’ icon on the top left side.
Under Format Style select Rules. Click on Add Rule and you can now change the color of bars based on mapped data.
b. Sorting - PBIVizEdit offers great sorting flexibility for all its visuals. Below, we have shown how to create and apply custom sorting based on the fields you choose.
For more details, visit Sorting section.