Relative Date Slicer

Question

I need a date slicer with some predefined values:

Today
Yesterday
This month
Last month
Last 3 month
This year
Last year
Custom

Upon selecting any of these values, the from and to dates should be automatically set. Can this be done?

v-xicai · Answer

Hi amalekshahi,&nbsp;Put your date on slicer visual , and there is a dropdown arrow on the upper right corner of the visual. You can choose "Relative" . Then when you select the day, month ,year and numbers, the calendar slicer that you want will show.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards,Amy&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amalekshahi · Answer

Thanks&nbsp;v-xicai&nbsp; but this is not the solution I was looking for. I am familiar with the relative option in date slicer but it isn't easy to use for beginners.

v-xicai · Answer

Hi&nbsp;amalekshahi ,&nbsp;Could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive&nbsp;and post&nbsp;the link here. Do mask sensitive data before uploading.&nbsp;Best Regards,Amy

amalekshahi · Answer

Hi&nbsp;v-xicai&nbsp;,&nbsp;I took a screenshot from a CRM application we use. You can find it here.Basically selecting any option (e.g. last 7 days) will set the from and to dates to current date - 7 days and current date respectively.

amalekshahi · Answer

Also this filter will be set against the date dimension's date column.

Forum Discussion

Relative Date Slicer - With some predefined date range

5 Replies

Related content

Relative Date and Custom Date slicers conflicting

Date relative and between range slicers

Relative Date Slicer

Relative Time with Slicer