Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |