Regional settings

[UserSam]

Hello to all,

I am writing to you because I have a problem with the language of my pbix. I made my development with my regional settings in French. But now I need them to be in English to have the names of the months translated into English.

To do this I modified the regional settings of my pbix file but also of my computer.

Even after this modification the name of the months (of my time dimension created in DAX) remains blocked in French.

For this project I have several excel sources and I also made many transformations on power query.

Maybe I forced a French parameter in a place I can't find?

[AlexanderPrime · Accepted solution]

Doing some searches on this site, it appears Power BI struggles with hierarchy language when the regional language is changed midway through it's existence. 

Two options.

1. Rebuild from scratch with English as the Power BI language at the start.

2. Manually create columns in Power Query to define the English month name based on the date information. 
This post https://community.powerbi.com/t5/Desktop/How-to-change-language-of-date-hierarchy-field/m-p/1365507#... has an example of a user who struggled with this too and ended up doing the manual route, hopefully that may help. 

[UserSam]

It's done, thank you. My data is now in English but my date hierarchy is not as you can see below.

When I want to display the complete date it is well in English but when I display only the month of the hierarchy it is displayed again in French

[AlexanderPrime]

You might have a step on the Power Query loading of the data table that setting the locale to French.

https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query This url has some good information that may help you either find where it's happening in Power Query (Transform Data) or to manually add a step to convert the month names into English.