Forum Discussion
Helper IFiltering out blank values in Power BI Report Builder?
Hi community, I'm looking for help with adding a filter in Power BI Report Builder to to filter out blank values. Thanks!
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.
1 Reply
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.