Custom Format String Breaks after each Application Update

[trux66]

I have a data model that uses a custom number format string to show data in millions of Euros (€ #,0,,.00"M";-€ #,0,,.00"M";€ #,0,,.00"M") and it works very well.

After each monthly update of the Power BI Desktop app any fields using this format string start showing (\€ \#\,\0\,\,.\0\0"M"\;-\€ \#\,\0\,\,.\0\0"M"\;\€ \#\,\0\,\,.\0\0"M") instead which isn't a valid format and doesn't show any values. I must edit each field and reset the custom format string to see the values in my reports.

Once I reset the format string and save the file, it's okay until the next monthly update is applied and the string breaks again. Not sure what is causing this, but it is becoming increasingly annoying to have to fix lots of these each month.

Hope this is a quick fix and can be resolved.

[v-lili6-msft]

hi

I have reported this issue internally, ICM: 239068391

will update here once I get any information.

Regards,

Lin

[michaelsh]

Yes, same here:

Measure format issue in april 2021 update - Microsoft Power BI Community

Please fix, until then downgraded to March version

Thanks!

[v-lili6-msft]

hi

I get this from PG:

Checked in the fix into master. Pull Request 168197 : Fix for ICM 239068391. FORUM - [Desktop] - Custom Format String Breaks after each Application Update

The fix should be available to CX in June

Regards,

Lin

[trux66]

@v-lili6-msft  That is great news. I look forward to not fixing these format strings yet again!

[Anonymous]

@v-lili6-msft 
Is there any chance that it will happen this month please
i have to many reports to fix, it will be nice if it will be this month
thanks