Need Help with autoselecting slicer based on certain date conditions

[rohit1992]

Hi, I have a date slicer like this which consists of monthly dates with date being always 01 - 

Goal: I would want slicer to automatically select the YTD months.
Example: Suppose if the current date or the refresh date is 1st May 2024, it should automatically select Jan to May month of 2024 and deselect the other months.

Please guide how this can be done.
Thanks in advance!

[rohit1992]

Thanks @ValtteriN , this gives clarity on how to proceed.

[ValtteriN · Accepted solution]

Hi,

Add this kind of column to your calendar table:

Current Year YTD = IF([Year]=YEAR(TODAY()) && [Month]<= MONTH(TODAY()),"Current Year YTD",[YearMonth])

Then use that as a slicer:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/