Changing display in BI report from "True"/"False" to "OK"/"Not completed"

[EriSte]

I have a BI report that lists all the variables linked to an activity in each row.

One of the rows consists of a "True/False" input. 

Is there any way to change the display in my BI report, so that it shows "OK" or "Not completed", instead of the standard "True/false"?

Im new to BI, so a detailed explination would be greatly appreciated.

Thanks in advance!

[EriSte]

I found out what the problem was. In my version of BI, everything has to be sprayed by ; instead of, 

Thanks everyone!!! 

[EriSte]

Thank you for all of the responses. I cant get the code to work, I always get the following error:

Unexpected expression "OK" 

Unexpected expression "Not Completed"

Everything else seems to fit the formula and be ok. Any ideas as to what I'm missing? 

[v-juanli-msft]

Hi @EriSte 

Please show a screesnhot of your formula.

Best Regards

Maggie

[amitchandak]

@EriSte , try one of the following

column =if('Table'[Column1],"OK","Not Completed")
Column = SWITCH(true(), 'Table'[Column1]== True(),"OK","Not Completed")

Column = SWITCH(true(),'Table'[Column1]= True(),"OK","Not Completed")

[negi007 · Accepted solution]

@EriSte  You can create a new calculated column with below dax syntex

Status = SWITCH('Table'[TF],"TRUE", "OK","FALSE","Not Completed")

Above code will work if your data type for true/false column is string

OR

Status = SWITCH('Table'[TF],TRUE(), "OK",FALSE(),"Not Completed")

Above code will work if your data type for true/false column is true/false type

Below picture will help you in creating the column

[ryan_mayu]

@EriSte 

You can create a column to switch the value.

Column = SWITCH('Table'[Column1],True(),"OK",FALSE(),"Not Completed")