What happens if both visual and page filters are applied?

[Anonymous]

Hello

I want to enable users to chose their own date filters on a page but I also want to always exclude today's date data from a particular visual on the page.

Is it possible to specify a relative date filter on the visual so that it will display all data apart from today's and then enable users apply page filters on top to further filter the data on the visual and the page according to their own date range?

Thanks!

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

I created the data:

Here are the steps you can follow：

1. Create measure.

flag =
IF(MAX('Table'[date])=TODAY(),0,1)

2. Place [flag] in Filter, set is=1, apply filter.

3. Use [date] as a slicer

4. Even if the slicer selects the date, only all data except today will be displayed in the visual object

5. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , You can use a visual level filter to exclude the data of today. But it will be limited by the range of page-level filter if any