Setting Date Slicer to default to the max date when dataset is refreshed daily

[purple_SP]

Hello all,

I have a report where the data is updated daily (where the most recent date is a few days lagged from the current date). I would like the date slicer to default to the maximum available date when the user opens the report. eg the current max date is 6/26/2023, so the report should look like this when it is opened.

However, tomorrow once it has been updated, it should be: 1/1/2023 to 6/27/2023 when the report is opened.

I've had a look around, but I can't find exactly what I'm looking for. I also want to know if it is possible to do this just within PBI service as I want to avoid editing my data model and having to do a full refresh of it due to the size. 

[Anonymous · Accepted solution]

Hi @purple_SP 

First you need to make sure that your data table contains the current maximum date, because you say that the most recent date is a few days behind the current date, the slicer can only return the largest date in the current data table, and then make sure that the data table contains the current maximum date, you can create a measure.

Measure = var a=TODAY()
return IF(MAXX(ALLSELECTED('Table'[Date]),[Date])=a,1,0)

Then put the measure to the slicer visual filter

Best Regards!

Yolo Zhu

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

Output