Filter to the last Report Date

[GAPER]

My table get refershed daily. How do I make sure my use is seeing the data with latest date? Thanks. 

[Anonymous]

Hi @GAPER ,

Here are two methods you can try to use to troubleshoot this problem.

Here is my test data:(Today is 2024/1/11)

Method 1

1.Drag the date field into the filter area. Choose "Relative date" filtering.  Select "is in this"  and apply filter

2.Final output

Method 2
1.Add a slicer to your report. Place date field into the slicer. Format the slicer to show a single date or a dropdown. Drag the date field into the filter area. Choose "Relative date" filtering.  Select "is in this"  and apply filter.

2.Final output

Best regards

Albert He

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

[GAPER]

But does this mean the user can't see other days? 

Why is PowerBI doesn't have the option to set the filter to the max value!!!

[Fowmy]

@GAPER 

Please refer to this video: https://youtu.be/KBEsPGxDxHM