Forum Discussion

Evogelpohl's avatar
Evogelpohl
Icon for Helper V rankHelper V
10 years ago
Solved

True/False Filter is now 0/-1 ???

Something odd happened today to a solution that has been working fine.   Note the horizontal slicer.  It is "TRUE" and "FALSE" in PBID.  When published to PowerBI.com, it becomes "0" and "-1"   H...
Need Help
  • ankitpatira's avatar
    ankitpatira
    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.

  • Evogelpohl's avatar
    Evogelpohl
    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's avatar
Evogelpohl
Icon for Helper V rankHelper V
10 years ago

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.

 

 

MatWebb's avatar
MatWebb
Icon for Advocate I rankAdvocate I
10 years ago

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?