Forum Discussion
True/False Filter is now 0/-1 ???
Evogelpohl is this still a problem? Powerbi service having gone through few updates can you pls check and see if issue still exists.
Looks fixed for me. I just created a conditional column that results in a Logical (TRUE or FALSE). It displays correctly in the service.
Probably related: I have a table visual showing a value that is originally boolean, but which I have set to show as an integer from Column Tools. Now, this works fine initially, with True becoming 1 and False 0. However, when I refresh the data, all the 1s suddenly become -1. If I switch the column back to True/False and then back to integer again, the values revert to 0 and 1. Seems like a bug to me.
Still getting that issue! For context for others - the reason I want to use whole number instead of boolean is because it allows me to use Conditional Formatting in a table. Conditional formatting in the table does not work with Booleans unless I use the 'COUNT' option, which of course is 1 for every row, regardless of whether it's true or false.
Still having this same issue, even after the January 2025 updates. This is so frustrating!
Seeing this error in October 2025, microsoft never fix anything and leave it up to us to workaround.
