AGE Range in Cluster Column Chart

[jkhan]

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 

Currently my visual look like above

Please help in this requirement 

[Anonymous · Accepted solution]

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.

[jkhan]

Hi Sean, Thanks for providing solution.....