Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Icon for Helper III rankHelper III
4 years ago
Solved

edit 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 e...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

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