Set current date as default date in slicer

Hi Shahinkmajeed,

You can't do this directly in the report designer, but you should be able to do some modelling to make it work. Here I made one sample for your reference.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwtNA3sNQ3MFTSUTJUitVBEjICChmhCoFUGaMKGQOFTJRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [date = _t, sale = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"date", type date}, {"sale", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if Date.IsInCurrentDay( [date] )
then "Today"
else [date])
in
    #"Added Custom"

Also you can use DAX to get the similar result.

Column2 = IF(Table1[date]=TODAY(),"today",CONCATENATE(Table1[date],""))

Here is the result for your reference.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/qbjxrul1ytjjq7d/slicer.pbix?dl=0

Regards,

Frank