How to fix conditional column True/False showing as -1 & 0 in Service?

[ERing]

I have a conditional column set up to return True/False, however the slicer on that field displays as -1 and 0 when my report is published to the service. Strangely, it shows as True or False in desktop.

Any ideas on how I can correct this so my slicer shows correctly in the service as well?

[Ritaf1983]

Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @ERing 
There are 2 ways to get the desired result :
1. Change the data type of your flag column to text:

2. Change the way that you write the formula to :

test 2 = if(your condition,"True","False")

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[ERing]

@Ritaf1983  Perfect. Thanks!