Forum Discussion
CharlotteCity12
Microsoft Employee
Microsoft EmployeeSuppress Values if under Ten
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)...
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 !
serpiva64
Solution Sage
Solution SageHi, 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 !