Default year should be current year based on system Date and Time.

[NavaneethaRaju]

Hi,

I have four years of data like 2018,2019,2020,2021,

For example:- in future if 2022 data has been added.  that time i don't want manually change the slicer year and save it as 2022.

*It will have to happen Automatically. advice how we set that. 

[Greg_Deckler · Accepted solution]

@NavaneethaRaju So, many times people add a calculated column like the following:

Slicer Column =
  VAR __CurrentYear = YEAR(TODAY())
  VAR __Year = YEAR('Table'[Date])
RETURN
  IF(__CurrentYear = __Year, "Current", __Year & "")

Then you set your slicer to Current and are done.