Forum Discussion

Walt1010's avatar
Walt1010
Helper V
2 years ago
Solved

Relative Date Slicer How to Create it

This must be just something  obvious, but how do I change a date slicer to relative date? The official Microsoft pages tell you to go to Slicer Settings/Options, but that menu configuration isn't on ...
Show and Tell
Tips and Tricks
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    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

  • Uzi2019's avatar
    Uzi2019
    2 years ago

    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!

     

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

This 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's avatar
Walt1010
Helper V
2 years ago

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's avatar
    bhanu_gautam
    Super User
    2 years ago

    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