Forum Discussion

rynhowl's avatar
rynhowl
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

null boolean value lumped in with false by slicer

I have a boolean column that is sometimes null, and I have a slicer in my report for that column. The slicer shows "True", "False" and "(Blank)" as options, but selecting "False" includes the "(Blank...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

So, what is the data type of your slicer column, boolean?

 

It could be that the blank is getting thrown in there because there are non matching rows in some connected table.

rynhowl's avatar
rynhowl
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

The column I'm using for the slicer is type "True/false". Is there a "boolean" type I'm missing, or is it just the "True/false"?

The only other table I have is a single value with the date, so I don't think it's a issue with other tables.