Forum Discussion
Text value TRUE/FALSE shows differently in PowerBI Service
Hi,
Column values in the text column are "TRUE" and "FALSE". They are used in measure A as a filter [Status]="TRUE".
Everything is working fine on the PowerBI desktop.
When solution is published in PowerBI Service, KPI with measure A is not showing correct values, it shows 0 as default.
I see that column [Status] in PowerBI service has different values "0" and "-1".
Does anyone know why the values of the column have been changed?
Thank you!
9 Replies
Hi. I'm not sure what's going on there. My recomendation would be to convert the column to True/False type. There is a type for that. The column icon should change for a check and X icon.
Once you have the column type changed like that you can write the measure like this:
Measure = ....... [Status] = TRUE()I think that way should change in Service.
Hope that helps,
Hi lale24
How do you view the [Status] column in Power BI Service? Can you show some screenshot about this problem?
In my test, I create a Text type column with TRUE/FALSE values, and publish the .pbix into the service. I put the column in a table visual. Values are displayed well both in Desktop and Service. The values are not changed.
Regards,
Community Support Team _ JingHi, were you able to find a solution? I just had that happen to me now where a dataset with true/false on powerbi desktop turned into -1/0 on powerbi service
Hi lale24 ,
As per my knowledge it's because of your measure.Try to use any alternate measure and see whether the same issue occurs or not.
Thanks,
Sai Teja
My measure basically was checking if the column was "True" and then calculating something. On desktop it worked fine but on web it was not evaluating "True" because the column came in as -1/0 instead of True/False. I was able to solve it by manually changing the column to True/False in the query itself
