Subscriptions - Date slicer doesn't update

[amalm]

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 it won't show the latest data. 

I want to set up email subscriptions on the Power BI service but I'm running into the same issue: the latest data is not shown automatically.

How can I set the Timeline slicer to update automatically to include the new date(s)?

[v-frfei-msft · Accepted solution]

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