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.
- 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