"Blank" value appears after filtering in Power Query Editor

[richardsim10]

Hi,

I've been trying to filter a column, here's what it looks like:

Filtering in Query EditorWhat I see in visualisation filter

Now when I choose to filter and leave only "Procore ERP Budget", here's what I see in the visualtion filter:

A "Blank" value appears despite not even being in the values in the Query Editor. I checked in Advanced Editor and even there, there's nothing.

Anyone might know what causes this and how to not have this "Blank" value appear?

[v-shex-msft · Accepted solution]

HI @richardsim10,

Actually, the blank item it is caused with relationship and no matched records.

I'd like to suggest to take a look at following link to know more about this issue:

Slicer showing Blank as a value when data does not have any blank values

Regards,

Xiaoxin Sheng