Forum Discussion

saunders's avatar
saunders
Helper II
9 years ago
Solved

Date format - Desktop vs. Service

Hi all,   I have dates formatted as dd/mm/yyyy in Desktop but when I publish to the service the format get changed to mm/dd/yyyy.  How can I force the service to respect my Australian date format a...
  • irmat's avatar
    irmat
    9 years ago

    saunders

    Hi,

    I had the same issue by using SSAS. I noticed that in SSAS the data on the data format on the date column was set to either General or short date. Setting the data format to dd/MM/yyyy fixed the issue.

    Hope this helps.

MatE's avatar
MatE
Frequent Visitor
6 years ago

Hi All,

 

I went through all the changes that you have mentioned here. However, Power BI service did not display the date format(dd/mm/yyyy) until I change the browser language. 

In this case, I was using Chrome. 

Chrome -> settings -> Default browser -> Language -> Add language -> Make sure that you have the correct language setting at the top.