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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors