cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
murphys1602 Frequent Visitor
Frequent Visitor

Custom Column response changing to "0" or "-1" in Online Report view

I created a custom column to render a "true" or "false" depending on specific criterion from other fields. In PowerBI Desktop, it works perfectly. In the online report view however, the "true" "false" has changed to a "-1" "0". 

 

Any idea why or what that is? 

2 ACCEPTED SOLUTIONS

Accepted Solutions
George1 Regular Visitor
Regular Visitor

Re: Custom Column response changing to "0" or "-1" in Online Report view

Check your modeling Data Type. Keep them as text if you want the words only and not True / False

murphys1602 Frequent Visitor
Frequent Visitor

Re: Custom Column response changing to "0" or "-1" in Online Report view

Fantastic! Thank you for your help!

2 REPLIES 2
George1 Regular Visitor
Regular Visitor

Re: Custom Column response changing to "0" or "-1" in Online Report view

Check your modeling Data Type. Keep them as text if you want the words only and not True / False

murphys1602 Frequent Visitor
Frequent Visitor

Re: Custom Column response changing to "0" or "-1" in Online Report view

Fantastic! Thank you for your help!

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 48 members 953 guests
Please welcome our newest community members: