Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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 !!
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 !!
Always it should select the latest date .. like below:-
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
@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 !!
@VahidDM Measure doesn't work on slicer.
if its possible, please send me PBIX file
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |