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.
This is a DAX formula that cannot reference parameters.
What exactly are you trying to accomplish?
did you get the solution for this - i'm trying to do the exact same thing. I put in the power query formulas for bringing back today's date but it's not extracting the date as the parameter, the parameter just shows the formula.
date.from(datetime.localnow())
