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.
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!!