Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
6 years ago
Solved

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:
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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.