topic Re: Relative Date Slicer - With some predefined date range in Developer

Relative Date Slicer - With some predefined date range

amalekshahi — Mon, 22 Apr 2019 04:59:52 GMT

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?

Re: Relative Date Slicer - With some predefined date range

v-xicai — Tue, 23 Apr 2019 09:32:23 GMT

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.

Best Regards,

Amy

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

Re: Relative Date Slicer - With some predefined date range

amalekshahi — Tue, 23 Apr 2019 17:02:18 GMT

Thanks @v-xicai 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.

Re: Relative Date Slicer - With some predefined date range

v-xicai — Wed, 24 Apr 2019 08:27:46 GMT

Hi @amalekshahi ,

Could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy

Re: Relative Date Slicer - With some predefined date range

amalekshahi — Wed, 24 Apr 2019 16:53:50 GMT

Hi @v-xicai ,

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.

Re: Relative Date Slicer - With some predefined date range

amalekshahi — Wed, 24 Apr 2019 16:54:38 GMT

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