Date slicer showing years not there in date field

[Vaishali04]

Hi All,

I have date field in my data model. I have kept that date field at UI as a slicer. But when click on year it shows those years also which are not there in date field .  eg 2009 , 2010, 2022. Why is  that so?

Please suggest solutions.

Regards

Vaishali

[Tahreem24 · Accepted solution]

@Vaishali04 That's a default behavior of Date Slicer. It will show up all the year irrepective of your Date's date.

One workaround is that you can split the Day, Month, and Year in individual slicer. Like I did for Year so it will only show as per your data available in Date table.

Year = YEAR(Calendar[DateColumn])

Likewise create for Month and Day.

[amitchandak]

@Vaishali04 , This happens with the Date Range slicer, know behavior.

You can check or log an idea -https://ideas.powerbi.com/ideas/