I have a simple calendar that looks like this:
Calendar =
ADDCOLUMNS (
CALENDARAUTO(),
"Calendar Year", YEAR ( [Date] ),
"Month Name", FORMAT ( [Date], "mmmm" ),
"Month Number", MONTH ( [Date] ),
"Day", DAY ( [Date] ),
"Quarter", "Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1
)
Not sure for what reason but it's showing dates till the 2025:
How is this possible?
CALENDARAUTO() gives a full calendar year for any dates in your whole model. You must have a future date in there somewhere. To suppress the values showing in the slicer, create a measure:
Measure = COUNTROWS(your fact table)
And add it as a visual filter to the slicer with value > 0.