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

[v0v0]

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!

[v-jingzhang]

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. 

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

[v0v0]

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]

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.