Translation of month names (Analysis Services model)

[Anonymous]

Hello Community,

In my Analysis Services model, I have a Dates table with a Day Date column in format D-M-YYYY HH:MI:SS as the primary dates column. 

From this column, I created several other date columns such as Year, Quarter, Month Number and Month Name. I do this in Visual Studio, via Power Query Editor --> Duplicate column Day Date --> Transform. For Month Name, I also did this:

This is generating month names in my system language (Dutch). At first I thought this was a cool feature as Microsoft is recognizing my Windows language and I assumed this would be translated back to the system language of a user with English (or any other) system language. However, every user now sees Dutch month names in the reports, regardless of their system language and location in the world. The same is happening for weekday names.

Can anyone tell me how this works? Should this not be automatically translated as this is all within the Microsoft family?

I also haven't found a way to change it to English in Visual Studio, it is always generating Dutch names. 

Any help would be greatly appreciated.

Thomas

[V-pazhen-msft]

@Anonymous 

If change both global and current file regional setting does not work. The workaround can be a month measure since you cannot create a column under Live connection mode.

Month = SWITCH(MONTH(MAX([Date])),
1,"Jan",
2,"Feb",
3,"Mar",
...
12,"Dec") ​

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , see if you need  this date setting

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Regional settings
https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions
https://superuser.com/questions/1419853/power-bi-desktop-number-format-shows-american-format-in-visuals-but-european
https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-query/

multilingual
https://www.powerbi-pro.com/en/creating-multilingual-reports-in-power-bi/
https://community.powerbi.com/t5/Desktop/How-to-create-Multilingual-Report-in-Power-BI/td-p/599696
https://www.youtube.com/watch?v=JJryD2dXVVw

[Anonymous]

@amitchandak Upon re-opening Visual Studio --> Query Editor on my Dates table, I see the names are now in English! 

This was because of using the Locale method from link https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...

In the code, I see the following: 

#\"Changed Type with Locale\" = Table.TransformColumnTypes(#\"Changed Type4\", {{\"Month Name\", type text}}, \"en-GB\")",

However, after deployment and refresh of the AS table, I still see Dutch names in my PBI. Do you have any idea?

Thomas

[Anonymous]

@amitchandak Thanks for your reply. Unfortunately, the links you provided under 'Regional settings' did not lead to a solution. As mentioned, other users in for example the USA are also seeing Dutch month names whilst their regional settings are different than mine. 

I got my hopes up with this link: https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...

I changed the type of the column and selected 'Using Locale'--> selected English, but nothing happens after that. I updated the table and even processed it into VS, but still the month names are in Dutch.