Bins and ranges

[rlsmith1994]

I have continuous data about GPA. I created groups. Power BI required bins, which is fine. 

I would like to confirm an element of bins. When I set the bin size to .25, it creates GPA categories: 2.00, 2.25, 2.50.....4.0. The total 'n' adds up. 

What I don't know are the ranges. So, if there are 256 people in the 2.50 bin, does that mean 2.25-2.75? Or 2.00 - 2.50? 

Thank you.

[v-rzhou-msft · Accepted solution]

Hi @rlsmith1994 

The range of 2.5 bin is 2.5-2.75.

I build a sample to have a test. In my sample size of bins is 0.25.

Table:

Visual:

You can add the max value and min value in tooltips to help you know the range of your bin. In my sample we can see that in 2.5 bin the min value is 2.51 and max value is 2.73.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[rlsmith1994]

Thank you!!!