New group -> How is the proposed bin size calculated

[elijah2018]

Hi community, 

To estimate a density function I grouped data together into bins  and plotted the bins on the X-axis and the frequency on the Y-axis. There is theory about how many bins to use to estimate the density function in a good way. 

So when ever I create a new group for this purpose, Power BI proposes a bin size. 
I want to know what this proposed number is based on ? I  was trying to google the answer without luck.

Thanks for your interest in helping me 

Regards 

Elijah

[v-danhe-msft]

Hi @elijah2018,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @elijah2018,

Based on my research, you could refer to this link to know the rule of the bin size:

https://en.wikipedia.org/wiki/Histogram#Rice_Rule

Regards,

Daniel He