March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello community,
I am implementing a date picker in slicer. I achived that by using 'before' option in slicer, and wrote DAX measure to bring selected date related value.
Calender table has dates from 2018 to 2023.
I want to set slicer Date to Today. How can i do this?
Don't want to use relative Date option.
Below Dax measure I am using to bring selected date event. That works fine.
Selected day Event =
Var selectedate = MAX('Calender Table'[Date])
return
CALCULATE(MIN(Data[Event Name]),TREATAS({selectedate},'Calender Table'[Date]))
Any suggestions please.
Thanks !
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@cv2qm
You can create another column in the calendar table to get the date from the beginning to today. Then use 'Before' option in the slicer.
Date-Today = IF([Date]<=TODAY(),[Date])
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1. I want to show report default for today everytime.
2. User can pick any date if he/she want to search.
But in your case it will always show today's date.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@cv2qm , there is way initialize on a function like today.
You can have a column like this in you date table sorted on date and use that to filter today
Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]=TODAY()-2,"2 Days Ago"
,'Date'[Date]&"")
In case you need more than a day data when you select only today -
https://www.youtube.com/watch?v=duMSovyosXE
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
I just want to show today's date in sllicer always, if i can use relative date in filters how can i set slicer today's date always.
User can pick any date from Slicer.
Thanks!
Power bi doesn't support set default option in a slicer. However, there is a workaround that is possible by creating a measure to show today()'s data when nothing selected in the slicer, meanwhile you can select other dates in the slicer, please see the attached pbix.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
86 | |
69 | |
61 |
User | Count |
---|---|
138 | |
121 | |
109 | |
99 | |
96 |