Forum Discussion
Need help in removing blank rows
Hi
I have raw data table in which there are about 4 rows that i want to remove which are blank in a particular column. I am choosing the column > Transform Data > Home > Remove Rows > Remove Blank Rows... but this is not working. What am i doing wrong? Also, i dont mind leaving them but how do i uncheck (blank) from the visual?
- Click on the View tab in Power Query editor and tick the box to turn on the Formula bar so you can see what the code is that happens when you click the buttons. I believe remove blank rows only removes rows that are entirely blank, while remove errors removes based on selected column. To remove blanks from a specific column, just use the arrow on the column heading to filter the column and untick blank/null values.
- Yes, so since those countries are excluded from your Country table, they will appear as Blank in the visual. You can just filter the visual to exclude blank in this case, or you will need to apply additional filter in the raw data to remove them from all tables.
11 Replies
- AllisonKennedy
Community Champion
Click on the View tab in Power Query editor and tick the box to turn on the Formula bar so you can see what the code is that happens when you click the buttons. I believe remove blank rows only removes rows that are entirely blank, while remove errors removes based on selected column. To remove blanks from a specific column, just use the arrow on the column heading to filter the column and untick blank/null values.
Tahreem24Super User
You are going in the right direction. Just do the little workaround if you are not getting from your action.
Go to transform query editor > select the column on which you wanna remove blank values then click on the small down arrow icon to get the list of values that are available on this column> uncheck the "null" value > Save and apply this changes.
Hi
I ran into a problem, am trying to build a connection with the same table. So i have the raw data table in which i have country column which has duplicates so am uploading a file with the list of the unique countries. when i connect the both, the (blank) re appears, why? I have applied filter (Blank) to that column and the Unique Country List table does not have any blank.
- AllisonKennedyDo you mean the blank appears in a chart or other visualization? This is usually because the country data doesn't have an exact match so blanks will appear in the visualization.