Forum Discussion
Solved
How to dynamically set the Parameter Current Value?
Under Manage Parameter, when i use Suggested Values as Query, is there a way to set the Current Value to one of the item in the query result? Example: if my query result is a list of dates, i wou...
As it looks, we cannot use dynamic values in parameters right now: https://community.powerbi.com/t5/Desktop/Options-to-have-report-parameters-similar-to-what-we-have-in/td-p/27746
So the option I see for you would be to add a column to your calendar-table where only for the current day, a fixed expression/value like "Today" will be returned. You could then "hardcode" that in your parameter.
Hello, resurrecting this one - I'm trying to do the same (fill in localnow as the current value by default, but can be overridden in Service if needed). Any new features that can allow this? Thanks in advance!