Forum Discussion
Regional settings
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#M584517 has an example of a user who struggled with this too and ended up doing the manual route, hopefully that may help.
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