Filter in Preview window not properly filtering for empty values

[edhans]

As you can see in this image, the Title field clearly has some blanks, and the dropdown filter shows it.

Selecting Blanks though returns no rows:

Which is correct, as this returns no records:
EVALUATE FILTER( 'Customers', ISBLANK('Customers'[Title]) )

But this does return records:
EVALUATE FILTER( 'Customers', 'Customers'[Title] = "" )

So the filter dropdown in the first image is missing the "empty" value, and I see no way to filter for empty. Doing Contains "" in the text filter returns nothing.

Is the only solution to write a DAX query manually?

[otykier]

Hi @edhans. Yes, I'm afraid this is a limitation currently on string-type columns, as the filter component we use apparently does not distinguish between blank and "". We'll see if we can address this in a future release - for now, a manual DAX query would be required.

[otykier]

3.3.0 now includes both blank and empty strings when filtering "(Blanks)". Use the advanced filtering options under "Text options" if you need more granular control.