Forum Discussion
Power Bi Paginated Reports expression ignores parameters?
Hi, TravisM
Yes, it is possible to ignore a parameter in Paginated Reports. One way to do this is to use a hidden parameter.
You can create a hidden parameter that has the same name as your date range parameter, but with a different default value. For example, you can set the default value of the hidden parameter to be a very large date range that encompasses all possible dates.
Then, in your expression for "most recent log in", you can reference the hidden parameter instead of the visible date range parameter. This will ensure that the expression always uses the maximum log in date across all dates, regardless of the date range specified by the user.
Here's an example expression that uses a hidden parameter called "DateRangeHidden" instead of the visible date range parameter:
``` =Max(Fields!LoginDate.Value, "DataSet1", Parameters!DateRangeHidden.Value) ```
Note that you will need to update the dataset reference and parameter name in the expression to match your specific report.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think I am misunderstanding a step. When I create a hidden parameter the system says I have to use a different name, I cannot use the same name