(blank) vs no value at all

[claireberry]

I have a table where the value under the filter dropdown has literally nothing, where the green check mark is, 

I also have another table with filter dropdown that says "(Blank)". 

I'm trying to convert the (Blank) into no value at all like in the first picture. How to do that? Thank you!

[Irwan]

Hello @claireberry 

i might be wrong, but blank his happened because of number format.

i think you need to change to Text and then replace value null to nothing.

Hope this will help.

Thank you.

[claireberry]

ok thank you for investigating! Though, these are values in a calculated table, so it doesn't appear in the transform page. How to do the replace action in the table view?

[v-stephen-msft · Accepted solution]

Hi @claireberry ,

Here're the steps.

1.To reproduce the scenario: there is (Blank) in the slicer.

2.Add a calculated column.

NewGender = IF([Gender]=BLANK(),"",[Gender])

3.Here's the result.

Best Regards,
Stephen Tao

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

[danextian]

Hi @claireberry 

(Blank) actually refers to a null value which means there isn't a value assigned to a it at all. The one with a white space has a value in it but may not have a width.

In order to convert null into a white space, right a cell containing in in the query editor then select replace values. Leave the second filed empty