Filter a SSRS Dataset based on a parameter value

[Sweets7]

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.

[v-xiandat-msft · Accepted solution]

Hi @Sweets7 ,

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.