Using the Bin/Grouping for Greater or Less than a value

[alee5210]

Hi everyone,

I have some data that I want to put into bins. The problem is that there are some outlier values, so I also want to have a greater than or less than bin. In my data below, I want to capture things that are less than 10 in one bin and things that are above 20 in another bin. Everything else would be a bin with the size of 1/have 10 bins (of size 1). I can create a conditional column, but the range on my dataset is quite large and would like a simpler way to do this. The optimal scenario would be to have the greater than bin/less than bin and for the rest of the data be able to select the size of bin or number of bins like Power BI currently has. Any ideas?

My data is:

1

10.5

11.76

13.24

13.5

15.9

17.5

19.9

23.5

28.2

Result would be:

<10: 1

10-11: 1

11-12: 1

12-13: 0

13-14: 2

14-15: 0

15-16: 1

16-17: 0

17-18: 1

18-19: 1

>20: 2

[vicky_]

There's a tutorial on something very similar here: https://radacad.com/create-customized-age-bins-or-groups-in-power-bi, but basically, it goes through some very common options on how to do dynamic binning. Hopefully something here will help you.

[alee5210]

I have seen this solution but this is only good if you do not have many bins. In my case I may have between 30-100 bins and they may change in the future. I do not want to use the conditional column method as it would be a big pain. I want something where I can set the number of bins or bin sizes (after confirming the greater or less than bins) and it will automatically make the bins. Hopefully that makes sense.

Edit: I just read that article further, especially the dynamic bins and that's helpful, but it does not give the the <10 bin or the >20 bin that I am after :S