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.
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.
Aye, you are right - ill have to add this to the 100 other little things im going to have to check to ensure i dont come unstuck later!
Thanks for the quick replys! always great to hear someone else has your issue and has additional info!!