Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@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 @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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |