Suppress Values if under Ten

[CharlotteCity12]

I want to remove the data lable number if the total is under 10.. Also place text "* age group -- under ten"

Data:

AgeGroup	TotalStudents
(0-2yrs)	9
(3 - 5yrs)	2
(6 - 11yrs)	17
(12 - 17yrs)	29
(18 - 21yrs)	24
Older	8

[serpiva64 · Accepted solution]

Hi, you can use a calculated column

AgeGroupGrouped = if ('Table (2)'[TotalStudents]<=10,"* age group -- under ten",'Table (2)'[AgeGroup])

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !