[BUG] Custom Format beginning with "mmm" automatically resolves the "mmm" into "\M\M\M"
In PowerBI Desktop v2.100.684.0 64-bit (December 2021) when I select a custom date format for a date field in the Model view, I can't get the custom format to accept either "mmm yy" or "mmm-yy". After typing in "mmm-yy" a custom format string, it is automatically converted into "MMM-yy" and then a few seconds later resolves as "\M\M\M-yy".
what I type:
what happens a few seconds later:
and then a few seconds after that:
I have set up date fields successfully with this format a few months ago, so looks like whatever bug is causing this was introduced within the past few releases of PowerBI desktop. Please help!
3 Comments
- v-cazheng-msft
Community Support
Status changed:NewtoAcceptedHi HughMcD
Have reported it internally(ICM 279455007). Will sync here once there is any update.
Best Regards,
Community Support Team _Caiyun
- v-cazheng-msft
Community Support
Hi HughMcD
We get feedback from our product team said that fix of this issue will be included in Feburary realeas of Power BI Desktop.
Best Regards,
Community Support Team _Caiyun
- AnonymousNot applicable
Hi I think this bug is related to the issue that I am seeing the Power BI Table review. The "MMM" appears in all rows on the Table for my Date columns.
The issue does not impact the Visualisations
Does the Incident ticket include this? v-cazheng-msft