Timeline slicer-Need a particular month and date slicer instead of all months in a year

[kads]

Hi team,

We need a solution to encounter a whole month and year in a timeline slicer while choosing particular month and year from the data table.

[Anonymous]

Hi @kads ,

I think you can generate a date table as you want by calendar or calendarauto function.

Date = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([date]),"Month",MONTH([Date]))

For reference: Using CALENDAR vs CALENDARAUTO to generate 'Date' table for year-on-year comparisons

Then create a slicer by Year and Month.

Best Regards,
Rico Zhou

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

[amitchandak]

@kads , Not very clear. But you are taking a custom timeline slicer , you can choose a month there too, by clicking on a month

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.