Forum Discussion
Filter a SSRS Dataset based on a parameter value
Is it possible to apply a filter on a col based on the parameter value passed?
or e.g if Parameter.value = Yes then filter ColumnA like '%United Kingdom"
else no filter
I know I can easily write this using a Stored Proc but I am using Power Bi Paginated reports pointing to a PBI Data model.
If there is an alternate approach then happy to try that too.
Hi Anonymous ,
Below is my table:
The following expression might work for you:
IIf(Parameters!ReportParameter1.Value = "Yes" And Fields!Name.Value = "%United Kingdom", Fields!Name.Value , "")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 Anonymous ,
Below is my table:
The following expression might work for you:
IIf(Parameters!ReportParameter1.Value = "Yes" And Fields!Name.Value = "%United Kingdom", Fields!Name.Value , "")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.