Forum Discussion
Dynamic Date Sicer
Hi Farmaan_1,
AFAIK, you can't have between slicer with relative date functionality. The max you can do is fix a start date which is usually an option for YTD/QTD/MTD defaults. But again, even in that case you need to update the slicer manually every year/quarter/month to fix the start date.
One work-around I can think of is having 2 buttons in the screen: One for relative date and one for custom date (between slicer). Default with last 6 month relative date so that data is only for last 6 months when user opens the dashboard. If the user want to select specific range, they can click on button saying custom date wherein between slicer appears and relative slicer disappears.
In short, 2 buttons:
Button 1: Relative Date -> Relative date slicer
Button 2: Custom Date -> Between date slicerYour requirement is a limitation in Power BI and I would suggest convincing the client for either relative slicer or above alternative where only an additional click is required.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
Hello Farmaan_1
Yes you can configure a Power BI date slicer to automatically default to the latest six months. Here’s the easiest way to set it up:
1. Add a Date Slicer
Insert a slicer visual and drag your date field into it.
2. Switch to Relative Mode
Click the dropdown arrow on the slicer and change the type to Relative.
3. Set the Range
Choose Months as the unit, and set it to Last 6 months.
4. Save and Publish
Once applied, the slicer will always show the most recent six months dynamically, without needing to republish or manually adjust it each month.
Bonus tip: You can also apply a Relative Date Filter in the filter pane if you prefer to control visuals without using a slicer.
This approach is simple, reliable, and works well for most reporting scenarios. Hope this helps!