Forum Discussion
Filter with two dates
using Selectedvalue funciton you can achieve this. Find attached the file which might help you
Hi FilipaPereira ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided. If you still require support, please let us know, we are happy to assist you. Thank you for all the members who have already provided helpful responses.
Thank you.
Yes, this is possible, but it can’t be done with a standard date slicer alone because slicers work on one date column at a time. You need to model the logic explicitly.
Use one Date table and check whether the selected date range overlaps your Start/End dates.
1) Create / use a Date table
Mark it as a Date table.
2) Create a measure
In Date Range =
VAR MinSelDate = MIN ( 'Date'[Date] )
VAR MaxSelDate = MAX ( 'Date'[Date] )
RETURN
IF (
MAX ( Fact[StartDate] ) <= MaxSelDate
&& MAX ( Fact[EndDate] ) >= MinSelDate,
1,
0
)3) Use it
Put 'Date'[Date] on a Between slicer
Add In Date Range = 1 as a visual-level filter
This keeps rows where the date interval overlaps the slicer selection.