Auto update end Date in slicer

[Manivannan]

Hi All,

I want to have a slicer to display sales of one week.

Is there a way to auto update end date based on the start date or to generate report based on one slicer?

If not suggest any alternatives to achive this.

Regards,

Manivannan M

[Anonymous · Accepted solution]

Have a look for a custom slicer from the store (its free) called "TimeLine Slicer".  It allows you to do selections on a weekly basis.  This may or may not give you the week you are looking for.

Alternatively, you could create a calculated field (in a date table, or your data) which calculates the week number and year, then you could make a slicer that lets you choose one of those.

[Manivannan]

Hi Ross,

I have created a calculated field for the Year, month & week. . . Its working fine, Thanks for the quick reply.

Regards,

Manivannan M