Exclude a data from displaying on a bar chart

[amabrenda1986]

I grouped the Intake age for Active intakes using this formula:

Intake Age Grouping = IF(Intakes[Age]>0,

SWITCH(TRUE(),Intakes[Age]<=7, "0day-1 week", Intakes[Age]<=21, "2-3weeks", Intakes[Age]<=31, "<1month-1month", Intakes[Age]<=365, "2months-1Year",Intakes[Age]>365, "more than a Year"))

However, when i put the result into a bar chart, I get the below screen shot, because the blank belongs to resolved intakes. Please how can i exlcude the blank from displaying on the bar chart?

[Leasie_7 · Accepted solution]

You should be able to apply a filter on the visual within the Intakes[age] field selectn advanced filter options and choose does not equal blank