Forum Discussion
Helper IFiltering Column in Paginated Report based on a Word
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)?
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 [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
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.
2 Replies
- SamInogic
Super User
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 [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
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.