Box Plot based on 5 values

[rschaudhr]

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! 

[Anonymous]

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

[mahoneypat]

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

[amitchandak]

@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

[rschaudhr]

Hi @amitchandak, I tried the box and whisker plot you mentioned and yes, it did not work for the data I have. 

[dexterian18]

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

[rschaudhr]

Hi @Anonymous 

Actually, one of my collegues figured out way to to use line and stack column chart to develop a visual. You will have to use format section to make changes. For example change lines into dashes. It does not make an actual box plot but it comes close to it.