Forum Discussion

jkhan's avatar
jkhan
Helper III
7 years ago
Solved

AGE Range in Cluster Column Chart

Hi Power BI Community,   I need to group age like 19-25  26-35   36-45   46-55  55-70 for MALE and FEMALE Count    Please help in this requirement   
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hello!

     

    I would create a custom column using the following dax formula:

     

    AGE GROUP = IF ([AGE] < 19, "<19",
    IF ([AGE] >= 19 && [AGE] <= 25, "19-25",
        IF ([AGE] >= 26 && [AGE] <= 35, "26-35",
            IF ([AGE] >= 36 && [AGE] <= 45, "36-45",
                IF ([AGE] >= 46 && [AGE] <= 55, "46-55",
                    IF ([AGE] >= 56 && [AGE] <= 70, "56-70", "71+")
                )
            )
        )
    )
)

    From there, simply use this column for the graph instead of the age column.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello!

 

I would create a custom column using the following dax formula:

 

AGE GROUP = IF ([AGE] < 19, "<19",
    IF ([AGE] >= 19 && [AGE] <= 25, "19-25",
        IF ([AGE] >= 26 && [AGE] <= 35, "26-35",
            IF ([AGE] >= 36 && [AGE] <= 45, "36-45",
                IF ([AGE] >= 46 && [AGE] <= 55, "46-55",
                    IF ([AGE] >= 56 && [AGE] <= 70, "56-70", "71+")
                )
            )
        )
    )
)

From there, simply use this column for the graph instead of the age column.