Forum Discussion
Default selector to current date?
Is there a way to set custom values as selector defaults? I know it was discussed years back but I can't figure out if this was ever done?
I don't want a relative date slicer control that says today, I want a drop down slicer but I want the current day (or any day formula set value) to default when the page loads.
OneWithQuestion unfortunately it is still the same case, you cannot have a default value. I think this is an idea on the ideas forum, you should vote for it.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
OneWithQuestion unfortunately it is still the same case, you cannot have a default value. I think this is an idea on the ideas forum, you should vote for it.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi OneWithQuestion ,
You can so like this.
1, Create a calculated column and add it to the slicer.
2, Set "Current Date" as the default value.
As the date is updated, this default value is always the current date.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
