Forum Discussion
empty table values
I think you have some empty rows and in table view they've jumped up to the top. If you scroll down is there any data further down? Or if you select one of the filters in the column headers, try unselecting blanks to see if this is the case.
If you have got blank rows, go into Power Query and select "Remove Blanks" on the table in question.
I think you have some empty rows and in table view they've jumped up to the top. If you scroll down is there any data further down? Or if you select one of the filters in the column headers, try unselecting blanks to see if this is the case.
If you have got blank rows, go into Power Query and select "Remove Blanks" on the table in question.
hi AlexanderPrime i had some empty rows at the top but while removing the blank rows from power query editor iam getting this error
It sounds like one of your number columns may have an invalid character hiding in it (like a letter or a comma)
I would check in Power Query to see which column contains it and amending it where possible. One way to help find is to use the Column Quality View in Power Query. Screenshot below for where to enable this
This will give you a breakdown over every column if the data is valid, empty or has an error and should help you find where the data isn't translating into a number.
