Filtering out blank values in Power BI Report Builder?

[Julia2023]

Hi community, I'm looking for help with adding a filter in Power BI Report Builder to to filter out blank values. Thanks!

[Anonymous · Accepted solution]

Hi, @Julia2023 

Based on your information, I create a sample table.

Right-click the Data Region and select Properties. In the properties dialog box, go to the Filters tab and click the Add button to add a new filter.

In the new filter expression, set the Expression to the field you want to filter on. For example, set Name, set the Operator to <> (not equal to), set the Value to a null value, and enter nothing.

Here is preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.