Forum Discussion
DateSlicer "Between" + MaxDate
Hello cn4422 ,
You have couple of options available and I have covered in a similar post, here is the link :
You can modify slightly to show max date instead of today, Kindly check and let me know.
I hope this helps.
Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.
Warm Regards,
Neeraj
Hi cn4422,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi v-saisrao-msft ,
thanks for the reminder - it took me a while - but I just replied to the user's suggestions.
Hi cn4422,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The response accurately addresses the OP's issue in part but doesn't fully meet the requirement. Using a visual-level filter with a DAX measure (Max Date) to cap the data at the latest available date while keeping the "Between" slicer for custom date ranges is a valid solution and directly addresses the OP's concern.
The Relative Date slicer is a dynamic alternative, but it sacrifices flexibility by only allowing predefined relative periods (like "Last X days") instead of custom start and end dates, which doesn’t fully align with the OP’s need.
The "Before" slicer is less relevant, as it doesn’t provide the same flexibility for selecting a custom date range. While bookmarks offer a manual reset option, it doesn’t solve the OP's requirement for an automatic update to the end date after a dataset refresh. Overall, the visual-level filter solution is the most accurate, but the Relative Date slicer suggestion may not fully meet the OP's needs for flexibility in date range selection.If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
