Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
elijah2018
Helper I
Helper I

New group -> How is the proposed bin size calculated

‎08-23-2018 01:51 AM

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

Labels:
Message 1 of 3
404 Views
0
1 ACCEPTED SOLUTION
v-danhe-msft
Employee
Employee

‎08-26-2018 06:49 PM

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 2 of 3
388 Views
0
2 REPLIES 2
v-danhe-msft
Employee
Employee

‎09-01-2018 01:58 AM

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 3 of 3
379 Views
0
v-danhe-msft
Employee
Employee

‎08-26-2018 06:49 PM

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 3
389 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All