Forum Discussion
Helper IIIedit Export to Excel filters
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
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
1 Reply
- v-janeyg-msft
Community Support
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