How the name of a column in a column chart is created when using group(bins) as an axis?

[pawel_gorski]

I've followed the MS Learn course on analytics in Power BI (Statistical summary). I created a histogram from sample financial data and got profit divided into 20 buckets. What is really surprising is that the name of the bin (displayed automatically in a tooltip) doesn't match any of the default statistics of the records in that bucket. It's not minimum, not maximum, not an average nor median. So what is actually displayed as the name?

[v-jingzhang · Accepted solution]

Hi @pawel_gorski 

According to your screenshot, I guess you set up the groups(bins) with the Number of bins type. If so, the value of the bin displayed in the tooltip is always less than or equal to the minimum value of the bucket. It is the boundary value between two buckets.

For example, I have an Age column including values from 0 to 60. I group this column into 6 bins, so the values of these bins will be 0, 10, 20, 30, 40, 50. These values are calculated according to the mininum value and maximum value in this column. It evenly divides the range.

However, when you calculate the statistics of the records in that bucket, it is calculating the minimum/maximum/average/median values based on the actual records in that bucket. So if you don't have an actual record which is equal to the bucket value (boundary value), you will find the bucket value is not equal to any statistics value. 

Hope this will make it clearer. 

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

[pawel_gorski]

Thank you, this all makes sense now 🙂

[lbendlin]

Are you sure it is not the average of the values inside the bin?