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.
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.
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?
Yes, I've learned w/ PowerBI to review each column-type in the get-data routine to ensure each is set to the right type. Decimals are decimals, currency is fixed, integer is whole, date is date (not datetime), T/F is boolean, etc.
I even go thru my data to ensure columns that hold values that represents ID's (like a primary key) are set to TXT so I don't get prompted to aggregate it.
It's a ritual I force upon myself even if it looks like it guessed correctly.
Expecting the service to coherce a text value to a T/F value may seem logical, but i never trust it.