Forum Discussion
Date Format Bug (\mmm-yyyy)
ButtersStotch I haven't seen this, but you could try converting it to Text field in Power Query so it's always exactly in format you want. Use Date.ToText() function:
Date.ToText([EOMdate], "MMM-yyyy")
I can confirm I've seen this several times. It's exhausting. Power BI has several really nice features, and has come on leaps and bounds recently, but bugs like this are beyond annoying - they are huge productivity soaks. The same happens on money fields - have reports formatted sensibly (in most cases for us, with 0DP) and then suddenly the 0DP is lost and they're displayed with up to nine insignificant decimal places. Makes my team look bad for no reason of theirs.
And can we *please* stop accepting workarounds to bugs in Power BI as a 'solution'. It's not a solution. The bug still exists.
Where do I get to vote on this to be fixed?
Thanks, AllisonKennedy , I suppose that could work. I just think it's odd that a published report could change on its own, on a very specific way.
Community ChampionYou're welcome ButtersStotch , dates and even TRUE/FALSE often change in the Power BI service. I guess it's due to updates from Microsoft and in this case possibly regional settings. Text fields are concrete, as they don't rely on custom formatting, so will never change. Unfortunately takes up a bit of space in the model, but that's what a Date table is for.