Forum Discussion
Helper IFilter Rows if a Column Contains Blanks in Paginated Reports
Hello,
I have a column called 'ProjectNames' in my data table which contains blank values.
I want to filter out rows that contain blanks in ProjectNames column.
How can I achieve this in Paginated reports under Filter section of Tablix Properties?
Hi Vishruti
If you want to filter out rows with null values in paginated report, you can try the solution from the following links:
Expression: =IsNothing(Fields!ProjectNames.Value）
Type: Boolean
Operator: =
Value: false
Result
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
4 Replies
Hi Vishruti
If you want to filter out rows with null values in paginated report, you can try the solution from the following links:
Expression: =IsNothing(Fields!ProjectNames.Value）
Type: Boolean
Operator: =
Value: false
Result
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
ExcelMonkeImpactful Individual
I would recommend filtering out empty cells in the Transform Data step of your table. Either by removing "Empty" or "Blank":
- Syndicate_Admin
Administrator
Hi, if the query comes from SQL, filter it with a where before taking it to PBI
- ExcelMonke
I'm not familiar with SQL, but once you connect it in Power BI you can go to Transform Data within the Table View (2nd icon on the left hand side of the window) and filter there.