Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
Solved! Go to 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/
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.
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.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |