Forum Discussion
Date Slicer should populate the date range using start date and end date columns using other slicers
Hi mvinaykumar2003 ,
Thanks for the additional details and screenshot.I’ve tried this in my setup.
When Start_Date and End_Date are treated as text, the slicers respond correctly to Reporting_Period and Current_Prev_Month selections .
this works because Power BI treats them as categorical filters.
However, when using real date types, slicers are designed to show a continuous range and won’t dynamically reduce their range based on slicer-driven logic.
If your goal is to display the dynamic Start and End Dates:Use two text slicers (Start_Date and End_Date)
If your goal is to filter other visuals based on this dynamic range:
Please try this:
Keep a proper Date table:
DateTable = CALENDAR(DATE(2021,1,1), DATE(2025,12,31))Use measure like below to identify selected range:
IsInSelectedRange =VAR _min = CALCULATE(MIN('Table'[Start_Date]),ALLSELECTED('Table'))VAR _max = CALCULATE(MAX('Table'[End_Date]),ALLSELECTED('Table'))RETURNIF(MAX('DateTable'[Date]) >= _min &&MAX('DateTable'[Date]) <= _max,1,0)Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.Thank you.
| Reporting_Period | Current_Prev_Month | Start_Date | End_Date |
| YTD | 0 | 1/1/2025 | 5/11/2025 |
| MTD | 0 | 5/1/2025 | 5/11/2025 |
| LTM | 0 | 5/11/2024 | 5/11/2025 |
| Custom | 0 | 1/1/2021 | 5/11/2025 |
| YTD | 1 | 1/1/2025 | 4/30/2025 |
| MTD | 1 | 4/1/2025 | 4/30/2025 |
| LTM | 1 | 4/1/2024 | 4/30/2025 |
Not able to attach the sample pbix file. posting the screen shots
Community SupportHi mvinaykumar2003 ,
Thanks for the additional details and screenshot.
I’ve tried this in my setup.
When Start_Date and End_Date are treated as text, the slicers respond correctly to Reporting_Period and Current_Prev_Month selections .
this works because Power BI treats them as categorical filters.
However, when using real date types, slicers are designed to show a continuous range and won’t dynamically reduce their range based on slicer-driven logic.
If your goal is to display the dynamic Start and End Dates:
Use two text slicers (Start_Date and End_Date)
If your goal is to filter other visuals based on this dynamic range:
Please try this:
Keep a proper Date table:
Use measure like below to identify selected range:
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.
Thank you.