edit Export to Excel filters

[vamshikrishna20]

Hello All, 

I have a Report Page with Line chart and Date slicer(between view). When User opens the Report and make change only in End date . it is just showing as "Filters Applied: Data before end date " which is not ideal case for us . 
for ex - on publishing the report if slicer shows 01/01/2001 and 02/02/2001 as start and end dates , when user changes the end date to 05/04/2001 and export . Excel is showing as data before 05/04/2001 where as we need it as Data between 01/01/2001 and 05/04/2001.

can some one help me with above requirement . 

TIA

[v-janeyg-msft · Accepted solution]

Hi, @vamshikrishna20 

According to your description, I think it should be a date smaller than that in the date slicer in the line chart.

So you can create a measure like this and apply it to visual level filter to filter date not in the range of the slicer:

Measure = if(MAX('Table (2)'[Column2])in DISTINCT('Table'[Date]),1,0)

Before:

After:

Then you can export data you want.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey