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!

     

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Walt1010 

 

yes. You are right because you are not using date field/ date table that's why relative date and relative time option is not visible to you.

see i have used calendar date so i ca see the relative date option 

 

 

where date is text format so only few options are visisble to me.like below

 

 

so try to format your date filed to DATE by using format option 

select your date column then select data type to Date then set your desired date option like MMM-YYYY etc .

 

 

I hope I answered your question!