Forum Discussion
Helper VTrue/False Filter is now 0/-1 ???
Community ChampionEvogelpohl is this still a problem? Powerbi service having gone through few updates can you pls check and see if issue still exists.
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