Dynamic Binning with Equal Number of Records

matsahiro — Tue, 30 Mar 2021 17:44:38 GMT

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.

Re: Dynamic Binning with Equal Number of Records

Anonymous — Thu, 01 Apr 2021 13:55:27 GMT

matsahiro

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

topic Dynamic Binning with Equal Number of Records in DAX Commands and Tips

Dynamic Binning with Equal Number of Records

Re: Dynamic Binning with Equal Number of Records