Use “” and the “is exactly” filter. This video could have been a blogpost. This blogpost could have been a tweet.

That said, this video contains a few extra nuggets that may be of use – how to create a listpage view that filters for blanks. How to use Power Query to report on records with blank values.

Hope you enjoy.

Some Concepts:

• Filter for blanks (use “” and “is exactly” filter)
• Add field to listpage
• Create view from filtered listpage
• Open in Excel
• Use Power Query to create filtered view of data
• Use Power Query to track changes to source data