Power query Blanks values

[cristianml]

Hi, I need to remove the blank option that comes from the list. Not sure why is showing blank as the list doesn't have blank values:

[v-juanli-msft · Accepted solution]

Hi @cristianml 

The second visual seems not to be in power bi, is it is under power pivot view in excel?

If so, maybe you add columns from different tables into one visual, then some columns will show extra blanks rows as it has no corresponding values to other columns.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.