Bug in April 2023 update

[Anonymous]

Hi All,

I have tried the new Dynamic format strings for measures but due to some incorrect formats i have rolled it back to the original format. the issue is that the measure displayed now not as before. see pics for refferences. how can i revert it back ??

Thanks, 

[Mahesha_Krishna]

I have tried the new Dynamic format strings for measures but have noticed for few of the numbers (% Ratings) in dashboard show wrong values. If you check in the attached Dashboard, if the % Rating is 10%,20%,30%,40%,50%,60%,70%,80%,90% or 100% then the rating is multiplying with 11. Example if the Rating is 0.6(60%) then it display 660%. Apart from these rounding rating numbers everything else display perfectly. Even the bar size looks fine. see pics for refferences.

- creating measure for % Rating with Dynamic format

- Selecting the format and specifying format for the % Rating and adding if the % Chg is >1.645 then Green dot, <1.645 Red Dot else nothing.

-  Created the Matrix view with bars as conditional format for values(%Rating). Here for Measure_1 BB it's 660% but actaul value is 60% and for Measure_2 all are 100% but display as 1100% means it's multiplying 11.

  

  

  

- But for Measure_7 all the values looks fine because values are not in the range of 10%,20%,30%,40%,50%,60%,70%,80%,90% or 100%

  

It's crucial for our Dashboards, please help ?

[OwenAuger]

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

[Mahesha_Krishna]

Hi @OwenAuger Excellent! and Thank you so much. It's worked as expected. 

[Vilmar]

I think it's a bug, but see if it helps.

• Click on the option you want to return;
• The message to change the format will appear. Click "change";
• Click again on Dynamic
  Obs.: Any alteration of this measure will have to do this

Video here 

[Greg_Deckler]

@Anonymous I have confirmed this. It appears that once you set your Dynamic format string that even when you change it back to Whole number for example and it says that you will lose your dynamic format string that the dynamic format string is still somewhat in effect. I would log this in the Issues forum. 

To get your original format back, switch the format back to Dynamic once again. This will give you the base format of "0". Then, switch the format back to Whole number. This will remove any vestiges of the original dynamic format string.

I'm just guessing but I'm thinking that perhaps dynamic format strings work by creating an Annotation on the measure and that removing the annotation is somehow not working correctly. Just a guess though.