Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Power BI date formatting not working as expected

I have two date columns - Data Entrega and Data Esperada - formatted as - mm/dd/yyyy. My clients are brazilian so they really want to read the date formatted as brazilian portuguese. I transformed th...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    The “Regional Settings” section of the Options dialog box only affects the behavior of power query, but not the formatting under the modelling section.

     

    In order to be able to set the Format to dd/mm/yyyy under the modelling section on your client PC, you will need to change the Local System Date Format under Control Panel > Region > Change date, time, or number formats on that PC first. Then you will see the dd/mm/yyyy option under the modelling section after reopen the pbix file. :smileyhappy:

     

     

    Regards

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello v-ljerr-msft,

 

Do you know if something changed, about the date format? 

 

I always do what you said to me. But now, I suppose that it is not working. Look, these are my configs:

 

 

But I can not see this date format on Power Power BI Desktop. Can you help me. please?

btiplady's avatar
btiplady
Regular Visitor
8 years ago

I've just started to experience the same issue - I've checked all of my regional settings in Desktop, Service and Windows and they are all set correctly to UK formatting.

 

In Desktop my dates are defaulting to dd mmm yyyy but the Format drop-down on the Modeling tab does not include dd/mm/yyyy