Date Control Filter single selection - do not want a range

Looking to change my filter on Date from a range like you see in the picture, to just a single selection. The data itself looks like this - 2022/06, 2022/07, 2022/08 and so on. Would love to just selected 1 period, rather than a range like the picture.

image

Can you set it to equal instead of between?

I like that - somehow I missed that, however I need to it roll up to the month as that’s what the periods represent. For example, 2022/10/01 shows data for the month of Oct, but 2022/10/02 does not. Any ideas?

Hmmm,

I would then look to making a date parameter and then use a calculated field that checks it being truncated down to the month.

ifelse(truncDate(‘MM’,${date_param})=truncDate(‘MM’,{date_field}),‘Show’,‘Hide’)

And then filter it down to only show ‘Show’.

Hi @ryanalbanamazon
Did @Max 's solution work for you? I am marking his (my) reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!