Forum Discussion
null boolean value lumped in with false by slicer
Hi,
After my test, i think it is a deafult design that if not True, return False regardless of whether is blank or not.
In other words, False includes Blank.
Best Regards,
Giotto
Hi, I know this post is from several months ago. But, I figure someone else is going to run into this and want an actual solution. I did a workaround where I added another text column for display with values: 'True', 'False' and null. The slicer works correctly based on that text column.
Thanks, but this isn't quite the issue I'm having. I'm importing data that has a boolean column, and some of that data is null. So the values in the column are TRUE, FALSE, or NULL. If I create a slicer on that column, it automatically lists all the values in the column, TRUE, FALSE and (Blank) which seems to be the replacement for NULL.
If it is going to display (Blank) as a separate value, it should treat it as a separate value. If it doesn't treat it as a separate value, it should be fixed so that it does. It seems like a valid filtering option, "Show me only data where this value is not null".
Hi,
After my test, i think it is a deafult design that if not True, return False regardless of whether is blank or not.
In other words, False includes Blank.
Best Regards,
Giotto