How to set a time slicer to select the latest date in default

[Anonymous]

Hello,

I have a dashboard that shows sales by day. How can I set in my date slicer to automaticly select by default the latest date in which I had data? Please note that there are some days that I don't have any data, thus the solution with the relative value does not work in my case.

Looking forward for your responses.

Many thanks,

MariosChr90

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

First, create a refresh schedule for your dataset following the steps in this article. Then create a measure to get the latest date using the formula and display it a card visual, when you dataset refresh, the measure returns the latest date automatically. Please note we can't use measure in slicer, we just display it in other visuals.

Latest Date=LASTDATE(Table[Date])

Best Regards,
Angelia

[MarkPalmberg]

I'm curious about the use cases for having a date slicer that *doesn't* update when a data refresh happens? Why would you even display this slicer in a report? If you really wanted a static date, wouldn't you just create a visual or report filter? This "non-updating date slicer" issue has really been a frustration, having come to Power BI from Tableau.

[Anonymous]

Thank you Angelia,

This looks to be a good way to solve my problem.

Many thanks for your help!

MariosChr90