Turning metric values into buckets in Power bi

Question

I have two columns of data like this:

Now I want to turn tenure into buckets like this:

I've searched but none of those works in Power bi. What should I do?

Answer 1

There is a very simple way to create groups and buckets. Simply right-click the field you want to group in the right bar and select "New group".

However, I find it quite finicky to use with fixed sized bins.

My preferred way it to simply create a new calculated column, using the SWITCH dax function:

tenure_group = 
VAR Val = Table[tenure]
RETURN
SWITCH(
    TRUE(),
    Val <= 5,
    "0-5 months",
    Val > 5 || Val <= 45,
    "6-45 months",
    Val > 45 || <= 69, 
    "46-69 months",
    "70+ months"
)