Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Hi Sean, Thanks for providing solution.....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |