Forum Discussion

amalekshahi's avatar
amalekshahi
Frequent Visitor
7 years ago

Relative Date Slicer - With some predefined date range

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 sh...
Need Help
amalekshahi's avatar
amalekshahi
Frequent Visitor
7 years ago

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.

v-xicai's avatar
v-xicai
Community Support
7 years ago

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

  • amalekshahi's avatar
    amalekshahi
    Frequent Visitor
    7 years ago

    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.

    • amalekshahi's avatar
      amalekshahi
      Frequent Visitor
      7 years ago

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