Forum Discussion
Helper VRelative Date Slicer How to Create it
Hi Walt1010 , I am attaching a PBIX file with slicer set as relative check this and try to replicate and let me know if you face any issue
Hi Walt1010
by looking at your image it seems you have taken something else means not a default slicer.
beacuse default slicer does not have all these option ( Shape , layout, callout value, Image)
see default slicer have following options only in the setting.
Please check the slicer you are choosing that causing an issue.
I hope I answered you question!
Helper VHi the field is definitely formatted as a date. As per my screenshot, my Slicer Settings looks different to yours:
Super UserThis is a data type issue you need to use date field/ date table for this create a calender table and mark it as date table then create relation ship with your fact table and use that calender table that is the ideal way of using date columns
- Walt1010
I've added a date table and connected my original date field to the date table. When I add a slicer, I still dont get any relative date options.
- bhanu_gautam
Hi Walt1010 , I am attaching a PBIX file with slicer set as relative check this and try to replicate and let me know if you face any issue