Forum Discussion
Box Plot based on 5 values
I have been tasked to create a box plot/box whisker plot. I have been provided the following data:
10 Percentile
90 Percentile
Average
Min
Max
So an example of the data set is:
| 10 Percentile | 90 Percentile | Average | Max | Min | |
| Company A | 90 | 120 | 100 | 120 | 80 |
| Company B | 18 | 70 | 20 | 80 | 15 |
| Company C | 30 | 80 | 40 | 90 | 28 |
The 3rd party visualization in Power BI cannot build box plot based on values provide above. Is there any other way to build this box plot based on data provided?
Thank you!
6 Replies
If needed, you can make the needed chart with Charticulator (or R or Python). Below is a link that demos Charticulator, along with a link to an example pbiviz that may work for you and the .chart file in case you want to modify it. Not you need to add an Index column to your data that will be needed in the top field well for the chart.
(1) Can You Say "Charticulator"? - I Knew You Could - Portland Power BI UG - YouTube
https://drive.google.com/drive/folders/1aXT-ByFx4wYp0avTq1uRx5atsyErwgCM?usp=sharing
Regards,
Pat
rschaudhr , You have Box and Whisker chart , But I doubt that can take value like that
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380831?tab=overview
bullet chart is another option -https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380755?tab=overview
Hi amitchandak, I tried the box and whisker plot you mentioned and yes, it did not work for the data I have.
Hi rschaudhr,
Were you able to resolve this? I am on similar situation where we are pre calculating the Boxplot Statistics due to the volume of data. As of the moment, we are using Paginated Report as the boxplot there accepts this dataset (similar to excel). I was wondering if you were able to implement this in a Power BI visual.
Thanks,
DEX
Hi rschaudhr,
I check the official visual and custom visual in the marketplace but I doubt they all not suitable for your requirements. (they do not support to display multiple aggregations at the same time)
For this scenario, I'd like to suggest you use script-based custom visuals(r, python) which allow you to manually plot and combine multiple graphs effect based on specific datasets.
Notice: these types of visuals not able to interact with other charts or visuals, but they can be effect/filter by others.
Regards,
Xiaoxin Sheng
