Time slicer with month and year

[thhmez7]

How can I have a time slicer with only month and year and without day?

[v-jiascu-msft]

Hi @thhmez7,

You can add a new column like this. Then you can add it to a slicer. But it will lose the feature of date. Because "month year" isn't a valid date format.

Month-Year = FORMAT([Date],"MM.YYYY")

Best Regards,

Dale