To select current year in my slicer when new data for current year

dboi , One of the option is that, you use preselected slicer

 

Or you can have this column in you date table and deafult on this year

 

Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

Hi dboi ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

1.Create calculate columns

Year = YEAR('Table'[Date])

Month = MONTH('Table'[Date])

Day = DAY('Table'[Date])

IsCurrentYear = IF(YEAR('Table'[Date]) = YEAR(NOW()), "Current", "Not Current")

2.Create a slicer use Year, Month, Day and apply IsCurrentYear as the filter of the slicer

Because filters cannot act directly on slicers with hierarchical filed values, so we need to create columns contain Year, Month and Day. When we create the visual object above, the slicer is empty because it is the year 2024 and the original data does not exist for the year 2024.

When we add 2024 data to the data, slicer shows the option to display the data now

Best regards

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly