Need help to implement date validations in PowerBI Report Builder

[SimG]

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. 

[Anonymous · Accepted solution]

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.