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 Blan...
- 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.
AllisonKennedy
Community Champion
Community ChampionI am assuming that you have the following setup:
DimCountry table with [Country] column with unique values.
Fact table with [Country] column with duplicates and [Value] column.
Visual (let's use matrix for this example) with DimCountry[Country] in Rows and Fact[Value] in Values.
Add Fact[Country] to the rows under DimCountry[Country] and expand the blank section to see which countries appear. Those are the ones without the match - maybe there's an added space or difference in capital and lowercase or something similar?
DimCountry table with [Country] column with unique values.
Fact table with [Country] column with duplicates and [Value] column.
Visual (let's use matrix for this example) with DimCountry[Country] in Rows and Fact[Value] in Values.
Add Fact[Country] to the rows under DimCountry[Country] and expand the blank section to see which countries appear. Those are the ones without the match - maybe there's an added space or difference in capital and lowercase or something similar?
You are exactly right and those are the countries i want to exclude as they will not have any values ever. that was the whole idea of having a separate table wxluding these countries so i can choose DimCountry for visuals