Writing a filter to override existing filter

[Anonymous]

Hi, I have filters that filter by date.

Based on certain parameters, I would like to create an option to change the Date filter on the fly, with a different date filter

Ex. the default is to show all records where the based on todays date (all records < todays date (ex. 4/8/20220)
I'm looking to create a new filter with an option, where if chosen would say "Show all records where intead of todays date, use last day in this month (ex. 4/30/20220)

Is there a way to create a filter that replaces the action of an existing date filter on the fly, in case the user chooses it?

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Maybe I'm not clear enogh to your problem. If there is a column of dates to be used as a slicer, in order to make the date displayed by the slicer earlier than today, you can create a measure like this:

Filter Measure =
IF ( SELECTEDVALUE ( 'Date'[Date] ) < TODAY (), 1, 0 )

Put the measure in the slicer visual filter and select it to 1, then the slicer will be filtered.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

That worked and thank you very much!

[Anonymous · Accepted solution]

That worked and thank you very much!

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ，

It's my pleasure!

If it helps, would you please kindly accept it as the solution, other members will benefit from it.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Maybe I'm not clear enogh to your problem. If there is a column of dates to be used as a slicer, in order to make the date displayed by the slicer earlier than today, you can create a measure like this:

Filter Measure =
IF ( SELECTEDVALUE ( 'Date'[Date] ) < TODAY (), 1, 0 )

Put the measure in the slicer visual filter and select it to 1, then the slicer will be filtered.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.