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 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)?

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

1 Reply

  • 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