Slicer option for (blank) when no blanks present in dataset

[Anonymous]

Currently an option is present in the slicer for (blank) when there are no blank rows in my data. I have tried to both filter out all blanks within query and the desktop and have been unsucceful. Using the query I also have selected "remove blanks" with no success. 

I am not sure if this is a known bug or if it may be something I am doing! Any comments or tips would be helpful! Thankyou(: 

- Austin I 

[v-lili6-msft · Accepted solution]

hi, @Anonymous

If your relationship tables contains records who can't correct mapping to related table, it will shows value as 'blank' option in slicer.(blank option means the missing records)

For example:

and create a relationship between them by "Type"

Then drag "Type" or "Color" into visual, (Blank) will display on slicer.

And If you slicer (Blank), visual will show data that table B can't correct mapping to table A,

here is a similar post for your refer to:

https://community.powerbi.com/t5/Desktop/Slicer-showing-Blank-as-a-value-when-data-does-not-have-any/td-p/301617

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft ,

I have similar case for my data, but I'm sure that all FK in my fact table already exist as PK in the lookup table. When I select <blank> it returns no data.

Is there anyway I can remove this without filtering the <blank> out? I need it there since it is a good indicator for any wrong data input.

Thank you.