Dynamic Binning with Equal Number of Records

[matsahiro]

Hello all, 

I'd like to create 5 bins, where each of the 5 bins has equal number of records. Currently, Power BI does have a binning feature, but it only allows for the same size of bins, not necessarily having bins with the same number of records in each bin. 

My dataset looks something like this

Account ID	Predicted Score
1	10
2	21
3	24
4	45
5	100

I'd like to point out that the visual will constantly be adjusted with filters. So the ranges of scores will constantly change. I need dynamic binning so that whatever data is inputted into the visual, there is always 5 set bins with approximately the same number of records in each bin. 

Any thoughts on how I should approach this? Thank you.

[Anonymous]

@matsahiro 

Please be more precise about what it is you want to achieve. Best, take a look at this.