Forum Discussion
True/False Filter is now 0/-1 ???
- 10 years ago
Evogelpohl is this still a problem? Powerbi service having gone through few updates can you pls check and see if issue still exists.
- 10 years ago
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.
Looks fixed for me. I just created a conditional column that results in a Logical (TRUE or FALSE). It displays correctly in the service.
- MatWebb9 years agoAdvocate I
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
- Evogelpohl9 years agoHelper V
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.
- MatWebb9 years agoAdvocate I
AH! now thats interesting Evogelpohl
Mine is also a TXT column, perhaps i should move to using proper true/false datatypes?
Do we think this is a 'feature' or a bug in the online service?