The default value of the slicer

[Gawain]

In my table, I create a new batch of data every once in a while, the CreateDate for this batch of data is the same, and then I add a slicer, and I want the default value of this slice to be the date that I updated last, and according to the data on the graph, the default value now should be September 1st, But I finished updating the data on 7th and the default value is expected to be September 7th. What should I do?

[amitchandak]

@Gawain , You have create a static column in you date table and use that in selection like geiven below. or you can try preselected slicer

Is MAX = if('Date'[Date]=Max(Sales[Date]) ,"Latest",[Date]&"")

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

https://appsource.microsoft.com/en-us/product/power-bi-visuals/insiderscoop1611244107840.powerbi_cus...