Forum Discussion

Manivannan's avatar
Manivannan
Icon for Helper I rankHelper I
9 years ago
Solved

Auto update end Date in slicer

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Manivannan
      Icon for Helper I rankHelper I
      9 years ago

      Hi Ross,

       

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

       

       

       

      Regards,

      Manivannan M