cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Evogelpohl
Helper V
Helper V

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"

 

Happening to others?

 

Capture2.PNG

 

 

Capture1.PNG

2 ACCEPTED SOLUTIONS
ankitpatira
Community Champion
Community Champion

@Evogelpohl is this still a problem? Powerbi service having gone through few updates can you pls check and see if issue still exists.

View solution in original post

Looks fixed for me.  I just created a conditional column that results in a Logical (TRUE or FALSE).  It displays correctly in the service.

View solution in original post

13 REPLIES 13
Vance_Tsai
New Member

It's Aug 2020 STILL a problem!

If you wanna fix this, try to use boolen type in your True/False column not use txt type.

Barbel
Regular Visitor

It's 2018 and this still hasn't been fixed. How is it possible??

August 2019 and we're still getting that issue Smiley Sad

ankitpatira
Community Champion
Community Champion

@Evogelpohl is this still a problem? Powerbi service having gone through few updates can you pls check and see if issue still exists.

View solution in original post

@ankitpatiraThis is still a problem and it appears to be a bug as it looks fine in the Power BI Desktop software however, the online version shows -1 and 0 for TRUE or FALSE. I hope Microsoft plans to fix this as I have way too many connections to have to create a conditional column for each one.

AbhiSSRS
Impactful Individual
Impactful Individual

This is still an issue! Would really help if this is looked at my Microsoft! 

 

https://www.c-sharpcorner.com/blogs/reports-doesnt-show-data-in-power-bi-web-service-after-refresh-i...

Looks fixed for me.  I just created a conditional column that results in a Logical (TRUE or FALSE).  It displays correctly in the service.

View solution in original post

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.

 

 Screen Shot 2016-09-08 at 11.20.54 AM.png

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

nmbalveren
Regular Visitor

It's happening to my reports when i want to show a chart with only the results of days in the current or previous week. Power M function Date.IsInCurrentWeek or Date.IsInPreviousWeek shows 0 or -1 instead of true or false in powerBI Desktop. This is really annoying when charts are not visible for the end user. Microsoft, is it possible to fix this!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.