Forum Discussion

JimN's avatar
JimN
Advocate I
9 years ago
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 would like to set the latest date as default and have my report use that when i first open the report.

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    JimN ImkeF 

    Appreciate assistance with the syntax.

    I have my date table and added the current day column as a new column

    isToday = IF('Date'[Date] = TODAY(), "TODAY", "")

    How should I use it in the parameter management form?

    Cheers!

    • ImkeF's avatar
      ImkeF
      Community Champion
      7 years ago

      This is a DAX formula that cannot reference parameters.

      What exactly are you trying to accomplish?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hey ImkeF 
        I want to set the current/default value in a parameter to today.

         

        Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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!