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.
Evogelpohl is this still a problem? Powerbi service having gone through few updates can you pls check and see if issue still exists.
ankitpatiraThis is still a problem and it appears to be a bug as it looks fine in the Power BI Desktop software however, the online version shows -1 and 0 for TRUE or FALSE. I hope Microsoft plans to fix this as I have way too many connections to have to create a conditional column for each one.
This is still an issue! Would really help if this is looked at my Microsoft!
The issue comes from when you have a column with TRUE/FALSE values and you leave its column type as text. During authoring in PBI-Desktop, everything works fine and PBI-desktop lets you use that field as a filter and it shows you the true/false values.
The same report continues to work fine after you publish it to PowerBi.com
The problem occurs right after a refresh is initiated in PBI.com. After that, what shows up as True/False suddenly shows up as 0/-1.
This difference in behavior between PBI-desktop and PBI.com has caused multiple teams at my company a lot of wasted hours trying to troubleshoot why its happening.
Seems like a bug to me.
Another observation: when you leave the column as text and PBI.com performs an automatic translation to 0/-1, the refresh takes a lot longer. In my case, locally the report refreshed in under 10 minutes. A refresh in PBI.com would take 30 minutes. Having fixed the issue, it now takes only 15 minutes. Very odd behavioral difference between PBI-DT and PBI.com
2nd August 2022: Problem persist. Funny and strange
Looks fixed for me. I just created a conditional column that results in a Logical (TRUE or FALSE). It displays correctly in the service.
This still exists as a problem.
I have poured 10's of hours into trying to resolve this one until i realised it was changing 'TRUE' to -1!!
Strange that some people see this ad resolved for them while others (myself included) still see the problem?
Any mods out there know more about this one?
Mat
I still have this issue if -and only if- my T/F column is set to TXT. It it is & I publish to the service, it goes to 0/-1.
If I change to a real T/F column in PowerQuery/Get-data from Text like below, then it resovles to TRUE and FALSE in the service.
