Forum Discussion
Power query Blanks values
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:
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.
1 Reply
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.