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?
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?
I was actually surprised that this seems to happen to only a few users. I haven't seen similar bugs like this reported. Also that currency thing. It's so annoying that I need to adjust the decimal places EVERYTIME I select "$" as the format. Why would I ever need 9 decimal places on a currency column?
