Problem using UNICHAR as the result argument of an IF function

[Anonymous]

When using two UNICHAR results for the return of a DAX IF function, the behavior is not expected.

As the following print screen:

The problem doesn't occur when using a UNICHAR result and a simple text 

Here is the DAX formula

SincroniaViagemDia = if( DATEDIFF('sir Viagem'[DataHoraSincronizacao],TODAY(),DAY)=0 && DATEDIFF('sir Viagem'[DataHoraFechamentoViagem],TODAY(),DAY)=0 , "OK", UNICHAR(9940))

[Anonymous]

Was able to work around this issue by following the advice suggested in problems using switch() function with unichar() Is there any news for the definitive solution for this problem?

[v-cazheng-msft]

Hi @Anonymous ,

May I know what’s the version of your Power BI Desktop? I tested with the latest version of Desktop(Version: 2.103.881.0 64-bit, March 2022). As you can see, it works well.

If you are not using the latest Desktop, please try with it. Here is the download link of the latest version: Download Microsoft Power BI Desktop from Official Microsoft Download Center. If you still have this problem in the latest one and don’t know the cause of it, could you please provide a download link of a sample pbix file that contains your issue so I can do further investigation on it?

In addition, please let me know how you configure your Regional Settings. Thanks in advance!

And I think you could try to replace the “(“ and “)” parts in your workaround formula with “” to remove ( and ) from the visual.

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

Same Issue.

Just updated the Power bi to the latest version 

The issue persists:

My regional settings:

I can't generate a PBIX file for my current report since it contains some personal data.