Bar Chart with Date Range

[jennifej]

Hi - I am trying to set a specific date limit/range on a bar chart. Here's what I need: 

I need to show the number of closed cases by closed reason . I also have a field for closed date but the data goes back to 2006 - and I only need to pull closed cases and the closed reason by date for the current year - so from 1/1/2021 and forward. 

Any insight would be very much appreciated!

[jwjackso · Accepted solution]

Try using an expression for the [Closed Date] dimension,

If([Closed Date] >= '1/1/2021',[Closed Date],Null())

and suppress nulls

[jennifej · Accepted solution]

This worked - thanks so much!!