HughMcD's avatar
HughMcD
New Member
4 years ago
Status:
Accepted

[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's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    Status changed:
    New
    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's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity 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

  • Anonymous's avatar
    Anonymous
    Not 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