Bug in April 2023 update

Hi Mahesha_Krishna 

In general, the format string expression should be designed to return the intended format string, rather than a formatted value.

Since your current expression returns a formatted value (using the FORMAT function), the resulting string is itself is being interpreted as a format string.

Taking the example where % Rating = 0.6:

1. The format string expression returns "60%"
2. This is itself interpreted as a format string. Since "6" has no special meaning in format strings, it is treated as a literal character, and the following "0%" is replaced by the formatted value "60%".
3. Putting these together, the result is the unwanted "660%"

I suggest using an expression like this instead (I have edited the code slightly to use SWITCH instead of nested IF, and I might have the wrong circle characters):

VAR Wt = [% Rating]
VAR T1 =
    SUM ( Sheet1[%Chg] )
VAR Result =
    "0%"
        & SWITCH (
            TRUE (),
            T1 > 1.645, " 🟢",
            T1 < -1.645, " 🔴"
        )
RETURN
    Result

Regards