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

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
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
9 years ago

v-ljerr-msft, thank you!