Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
v0v0
Advocate I
Advocate I

How to plot box and whisker with 30,000+ data points?

Hello,

I am trying to plot a box and whisker plot with 30,000+ data points. Is there any way to do this in Power BI? Perhaps a plot that takes summary data from a frequency table instead? I have a summary matrix on my dashboard as well which is accurate..but unfortunately when I hover over the boxplot that I have made, it does not match.

 

Thanks!

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @v0v0 

 

Are you using Box and Whisker chart by MAQ Software custom visual? It is required to use summarized data in values of the visual. You can right click on the values field and select an appropriate aggregation type for it or use a measure there. 

vjingzhang_0-1659343258719.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hello, yes I am using that visual.

However, it doesn't make sense for me to aggregate that visual...I have a column of 140,000 test scores. I would like to do a box whisker plot of the distribution of all of these scores - it doesn't make sense to aggregate them!

lbendlin
Super User
Super User

Thankfully not. It would be not just technically impossible but also physiologically useless.  

 

Power BI visuals have limits on the number of data points they are willing to display before they start forced grouping. It's 500 for tables, 1000 for scatter plots, about 2000 for maps etc.  But definitely far below your 30000.

 

As you said, pre-aggregation is a remedy.  Re-sampling is not, as it may lead to skewed results.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors