powerbidaxvisualizationpowerbi-desktop

Why is my calendar showing years in the future?


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:

enter image description here

How is this possible?


Solution

  • 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.