Forum Discussion

alexleyva's avatar
alexleyva
New Member
5 years ago
Solved

URL date parameter for Paginated Reports

I have a report that I has a date parameter.  I want to default it to today's date with the option for the user to change it to any date after it renders today's info.  I can hard code a date like so...
Paginated Reports
power bi
  • pabeader's avatar
    pabeader
    5 years ago

    Could you set a default value expression of =Today() in the parameter?

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, alexleyva 

 

The definition of the parameter can't use the dax function such as today(). You can manually enter today's date every day, or add a istoday column to the data source,Like istoday =IF ( table[date] = TODAY (), 1, 0 ), and then write the parameter like this: &rp:istoday=1.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.