Forum Discussion
Solved
Need Help with autoselecting slicer based on certain date conditions
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 curre...
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/
ValtteriN
Community Champion
Community ChampionHi,
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/