How to prevent the future from appearing in a time based slicer?

[agd50]

I only want the the max date to be the current month - how do I do this? (Not future months)

[amitchandak · Accepted solution]

@agd50 , Create a column in you date table

if([Date] <= today(), 1, 0)

use it visual level filter and filter for 1

you can also explore advance filter opion

[agd50]

You are a genius my friend, thank you very much.