Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
21 | |
20 | |
20 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |