Forum Discussion

amalm's avatar
amalm
Helper III
7 years ago
Solved

Subscriptions - Date slicer doesn't update

Hi,    I have the "Timeline 2.0.2" slicer on my report that I use to filter the dates.    Each time I refresh the data on the Desktop app, I need to update the the timeline slicer manually or...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi amalm ,

     

    Actually we cannot achieve that by using TimeLine. However, We can create a calculated column and add the column to Slicer visual to work around.

     

    Column = IF(MONTH(TODAY())=MONTH('Table'[Date]),"Curr",FORMAT('Table'[Date],"yyyymmm"))

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi amalm ,

 

Actually we cannot achieve that by using TimeLine. However, We can create a calculated column and add the column to Slicer visual to work around.

 

Column = IF(MONTH(TODAY())=MONTH('Table'[Date]),"Curr",FORMAT('Table'[Date],"yyyymmm"))

 

Regards,
Frank