Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
vamshikrishna20
Helper III
Helper III

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 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

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
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:

vjaneygmsft_1-1639030028167.png

After:

vjaneygmsft_0-1639030022759.png

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

View solution in original post

1 REPLY 1
v-janeyg-msft
Community Support
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:

vjaneygmsft_1-1639030028167.png

After:

vjaneygmsft_0-1639030022759.png

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.