How to change language on Date Hierarchy

[Cardi0z]

How can I change the language of the date hierarchy field from chinese to english?

[Anonymous · Accepted solution]

Hi @Cardi0z ,

Hope everything is going well.

You've provided a screenshot of the Regional Settings and it looks like the settings are correct.

After actual operation, it was found that there is only one way that this error will occur.

In order to reproduce your error, here are my steps:

1. When creating original data, the language type of the year, quarter, month, and day column titles of the date is Chinese:

2. Custom hierarchy:

3. Add year, quarter, month, and day columns to the custom hierarchy:

Your problem has been successfully reproduced.

Because the column heading language type in the original data is not English, there is currently no way to change the column heading language type after loading into the semantic model.

If you want to solve the problem, the only way is to create your data from scratch and make sure your header language type is English when creating the data.

Hope this solves your problem successfully, please feel free to contact me if you need any help.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[amitchandak]

@Cardi0z , Sometime, you have to rebuild from start. Check the previous issue

https://community.fabric.microsoft.com/t5/Desktop/Regional-settings/td-p/2568870

[jo1205]

Rebuilding the whole file worked for me! Thank you so much