Forum Discussion
Power Bi Paginated Reports expression ignores parameters?
I'm building a Paginated report that measures user activity within our system.
I have a set of parameters including a date range parameter with a start and end date.
One of the expressions I'm putting into the report is a "most recent log in".
But, when I use "max(logindate)" to get my most recent login, it's the most recent login based on the dates specified in the start & end date parameter.
So, is there a way that I can make this expression ignore the parameter? Is it possible to ignore a parameter in Paginated Reports? This is much easier in Power BI.
2 Replies
v-zhangtiCommunity Support
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
