Summary & Question
Users need to be able to filter on a column in the table and include "null/empty" values in that multi-select filter. What is the correct/usual way of solving this?
For example, one would wanna filter by "high" and "No value" in this case below and see table with both:
If just "high" is used, the user - as expected - only sees high:
Details / research
I've tried / thought of:
- adding "No value" in the filter option, something like this (I do not like this very much as it might be confusing to the user):
- one could have a checkbox near the filter somewhere that would say "Include empty" or something. Not entirely sure where that should be though - did not find the exact same problem anywhere although I'm sure I'm just googling wrong.
Questions I've already checked:
- This same solution has to work for search-select without preloaded options as well, which means that showing "No value" in there is not an option (although it would work if they typed that in, but feels entirely wrong as user cannot know what select option "empty" cell represents).
Any tips/ideas/research/links appreciated!!