Datamart breaking after applying Dynamic Formatting

When I change the Formatting for a Measure to Format = "Dynamic", I get the following error

 

Something went wrong

The changes below didn't work, so we've reverted your model to a working state. Try again.

Failed changes

  • setFormatting

 

After the failure, the Formatting is reset to what it was prior, but the Formatting pane for the measure breaks:

  • I can only see the "Format" option
  • I cannot see the detailed options (such as Thousands separator, Percentage format etc.).

CoffePotBot_0-1681920186683.png

 

In my affected Datamart, that we have been working on for some months, I am no longer able to create new measures or change the formatting options for existing measures. When I create a new measure, I am not able to save the measure through editing the DAX-editor field; I can only change the name in the sidebar. I'm not 100% sure this is related to this bug, but they manifested at the same time. The only workaround for getting detailed formatting options is through the Custom Format options.

 

I create a new Datamart to test in a pure enviroment, and the Formatting bug seems to be persistent.

However, it does correct iteself if I change Data formats to another type and then back.

This workaround does not seem to work for my affected Datamart.

CoffePotBot_1-1681920218706.png

Investigating v-yanjiang-msft (Community Support) responded

Hi @Anonymous ,

My interface is not the same as yours. When I click the measure in datamart, a tab "Measure tools" appears, and I can change data format there. When I change to "Dynamic", it also gets the same error message, which means the data cannot be changed to dynamic type, but after that all things still work fine.

vyanjiangmsft_0-1682059086578.png

Best regards,

Community Support Team_yanjiang

Comments
v-yanjiang-msft
Community Support
Status changed to: Investigating

Hi @Anonymous ,

My interface is not the same as yours. When I click the measure in datamart, a tab "Measure tools" appears, and I can change data format there. When I change to "Dynamic", it also gets the same error message, which means the data cannot be changed to dynamic type, but after that all things still work fine.

vyanjiangmsft_0-1682059086578.png

Best regards,

Community Support Team_yanjiang