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 

 

Currently my visual look like above

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.

2 Replies

  • 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.

    • jkhan's avatar
      jkhan
      Helper III
      7 years ago

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