selected Default date should be as last date on Date slicer

[Anshenterprices]

Hi Team,

Source data

Date	Sales
8/28/2021	129
8/27/2021	214
8/26/2021	299
8/25/2021	384
8/24/2021	469
8/23/2021	554

when user's open the report he should see default date is last date and after that he can select any other dates from the date slicer.and also daily user's need latest date and sales in pdf format via email subscription.



Thanks

[VahidDM]

Hi @Anshenterprices 

Could you please tell us more details about your request.

BTW, you can use LASTDATE dax code to find the last date.

Something like this: 
Last Date = LASTDATE(Table[Date])

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[Anshenterprices]

@VahidDM Please check.

[VahidDM]

@Anshenterprices 

Try to use this measure:

Last Date =
SELECTEDVALUE ( 'Table'[Date], LASTDATE ( 'Table'[Date] ) )

by default if nothing is selected, it will return the last date, otherwise, will select the selected date.

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

Appreciate your Kudos  !!

[Anshenterprices]

Always it should select the latest date .. like below:-

[Anonymous]

HI @Anshenterprices,

AFAIK, power bi slicers did not support setting default values.

For your requirement, I'd like to suggest you switch to relative date mode or create a calculated column to remark the last date, then you can choose this one on your slicer to pick the last date.

Regards,

Xiaoxin Sheng

[VahidDM]

@Anshenterprices 

It will return latest date if you don't select any date by slicer.

Try it and let me know if it does not work.

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

Appreciate your Kudos  !!

[Anshenterprices]

@VahidDM  Measure doesn't work on slicer.

if its possible, please send me PBIX file

[Anonymous]

Hi @Anshenterprices,

Any update for this? If you are not so clear about my description, you can check the below link about the last date on the slicer:

Solved: latest date in the slicer - Microsoft Power BI Community
Regards,
Xiaoxin Sheng