Date slicer in report to default to the latest available date when the report opens

[julesdude]

Hi,

 I know the answer to this used to be no, but wondered if any updates recently have changed this.

I have a report with a date slicer showing from and two dates that can be selected/chosen. The date slicer is linked to dates of records in my one table in my data model - very simple.

Can the report open to show the latest date where records are available and the 'to' date slicer default to that date rather than it having to be manually changed each time?

Or is there a workaround to inplement this?

[v-yangliu-msft · Accepted solution]

Hi  @julesdude ,

The report shows whether the latest date available for records refers to the current date. You can try using Preselected Slicer, but for vertical lists.

1. Then we find the "Preselected Slicer" and add the visual to our Power Bi Desktop.

2. First , we need to create a table with one column , and the value is True and False,.

3. Second , we can create a measure to define which the date we need to default preselected. If we need to default preselect then we return True else return False.

Flag =
var _date =SELECTEDVALUE('Table'[Date])
return
IF(_date = TODAY() , TRUE(),FALSE())

4. Then we can put the 'Table'[Date] in the Fields , [Flag] in the Pre Selection , 'Dirty Table'[Dirty Status] in the Dirty Status, like below screenshot:

5. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly