Exclude specific values from a table using Power Query (M)

[lucas_dantasc]

Hi All!

I have this data base:

And I would like to do somethings using M:

1. Exclude all values from the whole table if it is blank and null values from the column Grupo/Torre Responsável.
2. Exclude all values from the whole table if it is flagged as "Draft" in the column "Status da Vulnerabilidade"

[Nathaniel_C · Accepted solution]

Hi @lucas_dantasc ,
Go to the Home tab, select the column that you would like to filter. Click on the button at the top right of the column. Uncheck the null or blank, and other the other column, uncheck draft.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel