Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

[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:

HughMcD_0-1640206494160.png

what happens a few seconds later:

HughMcD_1-1640206508652.png

 

and then a few seconds after that:

HughMcD_2-1640206544875.png

 

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!

Status: Accepted

Hi @HughMcD 

 

Have reported it internally(ICM 279455007). Will sync here once there is any update.

 

Best Regards,

Community Support Team _Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Accepted

Hi @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

Daryl-Lynch-Bzy
Resident Rockstar

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.
DarylLynchBzy_0-1642073402206.png

The issue does not impact the Visualisations

DarylLynchBzy_1-1642073516951.png

Does the Incident ticket include this?  @v-cazheng-msft