Solved: Power query Blanks values

cristianml · ‎06-10-2020

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 · ‎06-11-2020

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.

View solution in original post

v-juanli-msft · ‎06-11-2020

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.