Filter Rows if a Column Contains Blanks in Paginated Reports

[Vishruti]

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?

[v-jingzhan-msft]

Hi  @Vishruti 

If you want to filter out rows with null values in paginated report, you can try the solution from the following links: 

reporting services - How to filter rows with null values in any of its columns in SSRS - Stack Overf...

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!

[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.

[Syndicate_Admin]

Hi, if the query comes from SQL, filter it with a where before taking it to PBI

[ExcelMonke]

I would recommend filtering out empty cells in the Transform Data step of your table. Either by removing "Empty" or "Blank":