Forum Discussion
Need help to implement date validations in PowerBI Report Builder
Hi,
I am trying to implement validations on date parameters in paginated reports in Power BI Report Builder.
Example: If there are 2 date parameters 'Date Range From' and 'Date Range To' and throw a validation message
"Date Range From must be less than Date Range To" when value in 'Date Range From' > 'Date Range To'.
Please suggest how can i achieve this behaviour.
Hi SimG ,
Below is my table1:
Below is my table2:
You can create two parameters:
The following Expression might work for you:
=IIf(Parameters!Date_Range_From.Value > Parameters!Date_Range_To.Value , "Date Range From must be less than Date Range To" , "")The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi SimG ,
Below is my table1:
Below is my table2:
You can create two parameters:
The following Expression might work for you:
=IIf(Parameters!Date_Range_From.Value > Parameters!Date_Range_To.Value , "Date Range From must be less than Date Range To" , "")The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.