Filtering Column in Paginated Report based on a Word

[Vishruti]

I want to apply a filter on a column in Power BI Paginated report based on a word. 

E.g. I have following data for the column - Project Names.

If the text in this column contains the word 'Demo' then I want to remove those rows. 

In the above example, I want to filter out the blue rows.

How can I achieve this in the Filter section of Tablix Properties (as shown below)?

 

[SamInogic · Accepted solution]

Hi @Vishruti 
 
For the SSRS report, you can add Expression as InStr(Fields!ProjectNames.Value, "Demo") and operator as greater than ">" and add Value as 0.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[sri_krishna_k · Accepted solution]

Hello Vishruti,

Instead of specifying a filter condition, you can use the visibility functionality.
1. Right click on the box below the column as shown in the below snapshot and go into textbox properties.

2. Go into the Visibility tab and select the options as shown in the screenshot.

3. Write the expression as shown below(Replace the field names with the fields present in your dataset)

Expression:

=IIf(InStr(Fields!Project_Name.Value, "Demo")>0, True, False)

Hit Ok and run the report, it should work.

Regards,
Sri.

[SamInogic · Accepted solution]

Hi @Vishruti 
 
For the SSRS report, you can add Expression as InStr(Fields!ProjectNames.Value, "Demo") and operator as greater than ">" and add Value as 0.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/