Forum Discussion
JimN
9 years agoAdvocate I
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...
- 9 years ago
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.